SAP Knowledge Base Article - Public

1218590 - How to select a Date or Date Time parameter value using the calendar in Crystal Reports?

Symptom

  • How to enter a Date or Date Time in a parameter using the calendar?
  • In Crystal Reports, when refreshing a report containing a Date or DateTime parameter, you are prompted to type a value in "yyyy-mm-dd" format or "yyyy-mm-dd hh:mm:ss" format, respectively. How can you use the calendar instead to supply a Date or DateTime parameter value?

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

Resolution

  • To use the calendar to supply the Date or Date Time parameter value, complete these steps:
      
    1. Click the 'Calendar' button next to the 'Please enter Date in format "yyyy-mm-dd" text box.
    2. Click the appropriate Date or Date Time value.
    3. Click 'OK'.

Keywords

CR, PARAMETER DATE FORMAT CRYSTAL REPORTS XI DATETIME PROMPT INPUT PARAM Crystal Reports Date parameter value Calendar , c2017235 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020