SAP Knowledge Base Article - Public

1653184 - Calculation of First Day of the Month in Crystal Reports

Symptom

 

How to Calculate First Day of the Month in Crystal Reports

Environment

 

Crystal Reports (All Versions)

Resolution

 

Need to add a formula in Crystal Reports designer.

Formula 1:

  1. Open Crystal Reports designer and create a formula as 

    2. currentdate - day(currentdate)+1
    Note : replace currentdate with your date field.

  2. Save formula and place it on report. 

Formula 2:

  1. Open Crystal Reports designer and create a formula as 

    2. Date(year({date_field}), month({date_field}),1)

  2. Save formula and place it on report.

    3.  

Keywords

 First day of the month formula, first day, date formula. , KBA , BI-RA-CR-DSL , Crystal Reports on Data Semantic Layer , How To

Product

SAP Crystal Reports all versions