Monday, February 2, 2015

Trouble searching with date format (US/UK formatting)


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".




Olaf Helper


[ Blog] [ Xing] [ MVP]

No comments:

Post a Comment