Is it possible to declare a date range as a variable? I have divided my report both annually and by month. What I want to do is compare the most recent fiscal period to the previous comparable fiscal period (fiscal year to date '01 vs. fiscal year to date '00 of a comparable period).

This is what I have tried to do:
datevar fy00;
fy00 := ({IH61C Header information.Invoice date} in date (1999, 03, 01) to date (2000, 02, 29));
datevar fy01;
fy01 := ({IH61C Header information.Invoice date} in date (2000, 03, 01) to date (2001, 02, 28))
but I keep getting an error message that it expects a date.

Is what I am trying to do possible at all?

Thanks,

David M. Concannon

Hello,

The date range that you are trying to use cannot be placed in a variable. Variables can only have one piece of data for the range.

You will need to create a formula for the date ranges you want on your report.

I have created a similar report using a formula and no errors were found. Here is an example of the formula:

if {AR61A Historical Customer Transactions.Document date} in Date (2000,03,01) to Date (2001,02,28)
then {AR61A Historical Customer Transactions.Original amount} else 0;

if {AR61A Historical Customer Transactions.Document date} in Date (1999,03,01) to Date (2000,02,29)
then {AR61A Historical Customer Transactions.Original amount} else 0