Who's On?

	Membership:
	Latest: Alanna
	Past 24 Hours: 0
	Prev. 24 Hours: 1
	Overall: 5294

	People Online:
	Visitors: 347
	Members: 0
	Total: 347

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244

How to set the date parameter format to ddmmyyyy(UK format)?

1 Replies

0 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

eve

New Member Send Private Message

Posts: 1

11/10/2014 1:50 AM

Hi,

When viewing the report in Crystal, date parameter is correctly displayed as ddmmyyyy following the viewing locale setting as UK.

However, when the report is published to LBI, the date format becomes mmddyyyy (US format).

Both system and user locale in LBI have been set as UK but there is no change.
Has anyone encountered the same? Is there any way to resolve this?

Thank you!

Matthew Nye

Veteran Member Send Private Message

Posts: 514

11/10/2014 9:42 AM

date formats are specific to the server environment. you will have to change the default date format on the server OS with the RAS engine is installed (ie Windows Server) in order for dates to display by default as you want. Another option would be to force the date format using formulas in Crystal.