petejigsaw
MIS
I have a simple report which pulls back sales and associated data for two user specified periods.
It is currently set-up with 4 date parameters - a start date and end date for each period:
{daily_summary.summary_date} in {?Start Date} to {?End Date} or
{daily_summary.summary_date} in {?Start Date 2} to {?End Date 2}
However, I would like to know if I can simplify the date entries so that I can specify a start date and end date, without including the year, so that I can retrieve multiple years for easy comparison.
Obviously I know I could use a cross tab report for simple data, but that isn't suitable for this report.
Is there a way of entering simply 2 dates - say 1st January - 20th January - and getting the report to pull back all records within those dates for ANY year?
Thanks in anticipation.
It is currently set-up with 4 date parameters - a start date and end date for each period:
{daily_summary.summary_date} in {?Start Date} to {?End Date} or
{daily_summary.summary_date} in {?Start Date 2} to {?End Date 2}
However, I would like to know if I can simplify the date entries so that I can specify a start date and end date, without including the year, so that I can retrieve multiple years for easy comparison.
Obviously I know I could use a cross tab report for simple data, but that isn't suitable for this report.
Is there a way of entering simply 2 dates - say 1st January - 20th January - and getting the report to pull back all records within those dates for ANY year?
Thanks in anticipation.