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