Hi All
I have a report which contains a date parameter where the user selects the start of range date and end of range date. The data is displayed correctly - no problem
In the Report Header, I have placed a formula with the following code
WhilePrintingRecords;
DateVar date1;
DateVar date2;
date1:=Minimum (
{@NumToDate});
date2:=Maximum (
{@NumToDate});
"Report For Period: " + totext(date1) + " To " + totext(date2)
Now what happens is that when the user selects a date range, for example 10th October 2011 to 20th October 2011, but data exists from 12th October 2011 to 20th October 2011, so the report prints as :
"Report For Period 12th October 2011 to 20th October 2011.
What I need is that it should print : Report For Period 10th October 2011 to 20th October 2011. This is the date range that the user selects
Rgds
Noel