1 Year Date Range Formula in Filters

[msi30502]

Hi,
I'm trying to generate a report that tells me all the items each customer purchased in the period of one year. I want to include this in my filter, so that we don't have to manually enter dates in parameters.

Crystal does not give me a pre-defined Function for my purpose. I currently have:

{JrnlHdr.TransactionDate} in LastYearYTD

but, as you can guess it only gives me data for January 2011 through May 2011.

What I really need is to run a report for 365 days through today.

Thanks in advance...

 

[pmax9999]

Hi msi30502

{JrnlHdr.TransactionDate} > DateAdd("yyyy", -1, CurrentDate) will give you transactions since 16 May 2011.

Regards
Pete

 

[msi30502]

Thanks, it worked. I'm guessing that If I wanted to go back only 6 months it would be:

{JrnlHdr.TransactionDate} > DateAdd("MM", -6, CurrentDate)

Is this correct?

 

[SkipVought]

Did you try it?

Did it give you expected results?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]