Trouble searching with date format (US/UK formatting)

Hi all,

I have a report with a date field ('Created On Or Before') which, when the report is executed, gets a list of opened cases from the date before the value entered. This works fine only when the date is typed in mm/dd/yyyy format. If I type it in dd/mm/yyyy format, there is an error whenever it falls outside the US bounds of the date format (i.e. when I type 15/12/2014):

When a valid date is entered in MM/DD/YYYY format, the data which is returned (from Dynamics CRM) is in DD/MM/YYYY format. The data in CRM is all in DD/MM/YYYY format, including the 'createdon' field which is being searched in this report. The language of the report is English (U.K). Can anyone provide any tips so I can search in DD/MM/YYYY format?

Thanks

February 2nd, 2015 6:14am

The data in CRM is all in DD/MM/YYYY format,

Date values in a database don't have any format, they are stored internal as numeric value; it's always the frontend which presenst & formats the date value.

And in Report Manager UI the format depends on the regional settings of your Profile and/or you browser. If it's Internet Explorer, open the Setting, on the first tab there is a button "Language" where you can change the language to "English-GB".

Free Windows Admin Tool Kit Click here and download it now
February 2nd, 2015 6:25am

Thanks for your reply - the language is already en-GB. The language setting of the report server is also English UK. The browser settings for both chrome and IE are English! :( still no luck
February 2nd, 2015 6:39am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics