SAP Knowledge Base Article - Public

1307953 - To retrieve data from last year May 15th to current year May 15th in Crystal Reports..

Symptom

Unable to retrieve data from last year May 15th to current year May 15th.

Reproducing the Issue

1.Creat a report.

2.Add a date field . Try to filter data using a date.

3.Want to retrieve data from last year May 15th to current year May 15th.

4.Write the formula to filter the data:

Crate_dt >= cdate (year (currentdate)-1, 5, 15) and Crate_dt<=cdate (year (currentdate), 5, 15)

Resolution

1.Using the same formula,

Crate_dt >= cdate (year (currentdate)-1, 5, 15) and Crate_dt<=cdate (year (currentdate), 5, 15)

 we can retrieve data for any month ie.last year particular month (Eg: May) to current year particular month (Eg.May) by changing the month and date according to our requirement.

Keywords

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

Product

Crystal Reports 2008 V0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2