PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 11/10/2014 4:42 AM by  Matthew Nye
How to set the date parameter format to ddmmyyyy(UK format)?
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
eve
ics consultant
Private
New Member
(1 points)
New Member
Posts:1


Send Message:

--
11/09/2014 8:50 PM
    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
    Private
    Private
    Veteran Member
    (1532 points)
    Veteran Member
    Posts:514


    Send Message:

    --
    11/10/2014 4: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.
    If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
    You are not authorized to post a reply.