record selection based on date field

[ABSquare]

Hi,
I am working on a crosstab report with the order date (current year MTD) in rows. Now I would like to add the previous year month to date values underneath it in the crosstab with the percentage difference.

In my record selection criteria, I have given the following condition and still it is not working

{Acquisition.Order Date (mm/dd/yyyy} in monthtodate
or
{Acquisition.Order Date (mm/dd/yyyy} in lastyearMTD

I would appreciate if somebody could help me with the logic or formula.

Thanks in advance

 

[hilfy]

If you have other selection criteria, you'll need to use parentheses around your "or" statement. Like this

({Acquisition.Order Date (mm/dd/yyyy} in monthtodate 
or
{Acquisition.Order Date (mm/dd/yyyy} in lastyearMTD)

-Dell


A computer only does what you actually told it to do - not what you thought you told it to do.