Custom report date format issue after deploying to CRM RRS feed

  • 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,


    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.



    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.


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



    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 AM