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

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

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)

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.

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

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