1308035 - How to retrieve last 3 months data in crystal reports.

SAP Knowledge Base Article - Public

1308035 - How to retrieve last 3 months data in crystal reports.

Symptom

How to retrieve the last 3 full months data for a date value in a crystal report.

Resolution

  1. Open Crystal Reports
  2. Go to Reports Tab > Selection Formula > Record.
  3. Write selection formula as:
  4.     DATEDIFF (m, date, getdate ()) <= 3 And DATEDIFF (m, date, getdate ()) >= 3

Keywords

KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

SAP Crystal Reports XI