Asked by:
Custom report date format issue after deploying to CRM

Question
-
HI All,
I have created multiple reports in visual studio using fetchxml and stored procedures with custom date parameters (date picker), when i deploy these reports in CRM, the date format is mm/dd/yyyy which is not correct. The date format settings in the CRM are dd/mm/yyyy both at the server and at user level. Request you to help on this asap
Thank you,
Naresh.
Thursday, January 30, 2014 9:07 AM
All replies
-
Hello,
You need to either use textbox property to customize date field on report rdl or update SQL Query to get output in format you want.
Here is a link for second approach : http://www.sql-server-helper.com/tips/date-formats.aspx
Use format which you prefer to use.
THanks
------------------
If my answer helped you, kindly mark it as an answer. That might help someone else in future too
Thursday, January 30, 2014 9:43 AM -
HI,
When I preview the report in Visual Studio i can see the date parameter format as required i.e; dd/mm/yyyy, but after i deploy the report to CRM the date parameter format is changed to mm/dd/yyyy even if all the settings related to date are in required format everywhere. Pls help.
Thanks...
Thursday, January 30, 2014 9:47 AM -
Okay. Do following 2 steps :
1. Go to CRM and go to system settings. Check the date format there, It is under Formats
2. Then check your own personal Format options under, File --> Options.
See if the formats are fine. I think thats where you are getting different format for dates. It is by default set to US settings
Thursday, January 30, 2014 9:51 AM -
HI,
Both the settings that you mentioned are good but still am facing the problem.
Thank you...
Thursday, January 30, 2014 10:01 AM -
Hi
Check the below links..
http://social.microsoft.com/Forums/en-US/7277b11b-226c-4b57-a8bc-664fc499ff6d/urgent-how-to-change-date-format-in-date-picker-for-ssrs-fetchxml-reports-for-mscrm-2011?forum=crmdevelopment
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/32b62d3c-9a32-41bd-b7ad-95c3b89a7668/ssrs-datetime-parameter-value-should-display-in-ddmmyyyy-format?forum=sqlreportingservices
Hope this helps..
- Edited by Suresh Sorde Thursday, January 30, 2014 10:21 AM
Thursday, January 30, 2014 10:18 AM -
If you want a specific format for a date field in a report, set the Format property of the text box in the Report Designer to that format (e.g. dd/MM/yyyy). This will override the language settings
Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk
Thursday, January 30, 2014 11:03 AMModerator