1542533 - How to change the date format of the date prompt

How to change the default date format of "Datetime" parameter in Crystal Reports

• Crystal Reports 2008
• SAP Crystal Reports 2020

Create a report with date parameter and it prompts with Calendar and default format "mm/dd/yyyy"

This is By design and there is a workarond solution: 1652217

WARNING: The following solution involves customizing product configuration files and not supported, Please use it at your own risk and note, the changes apply for all reports.

To change the date format we have to follow the below steps:

1. Open the JavaScript file "calendar2.js" in Notepad from the location: C:\Program Files\BusinessObjects\Common\4.0\crystalreportviewers12\prompting\js\promptengine_calendar2.js

for Crystal Reports 2020 the file located at:  C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\crystalreportviewers\prompting\js  

    2.   To change the default date format to "yyyy-mm-dd" of the "Date" type parameter change

          "this.dateFormat = dateFormat" to " this.dateFormat = "yyyy-mm-dd" " in the file

     3.  To change the default Datetime format to yyyy-mm-dd hh:mm:ss of the "Date" type parameter change

          " this.dateTimeFormat = dateFormat +  " " + "hh:mm:ss" " to " this.dateTimeFormat = "yyyy-mm-dd" +  " " + "hh:mm:ss" " in the file

     4.  Save the JavaScript file after making changes and restart Crystal Reports.

     5.  Check that now onwards the date format is yyyy-mm-dd.

 Note: List of available date formats are given in the file: C:\Program Files\Business Objects\Common\4.0\crystalreportviewers12\js\external\date.js

Date format , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To