Forums
Lawson Business Intelligence/Reporting/Crystal
How to set the date parameter format to ddmmyyyy(UK format)?
Author
Messages
eve
New Member
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
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.