Entering date and displaying last 12 months 3

[mitmat]

Hello Guys

I'm trying to run a report that asks for a call open date and then only displays the last 12 months from the date entered.
Currently the Parameter asks for start and end date but this appentley isn't good enough.
Any help will be most appreciated..

Matt

 

[lbass]

If you literally mean the last 12 months, then you could use a record selection statement like:

{table.date} in dateadd("m",-12,currentdate) to currentdate-1

Or, if you mean the last 12 full months, then try:

{table.date} in dateadd("m",-12,currentdate-day(currentdate)+1) to currentdate-day(currentdate)

-LB

 

[mitmat]

Thanks Ibass,

This gives me the previous 12 months from Currenttdate.
Is there a way of setting it to list only the previous 12 months from the Parameter date that's entered by the user

Matt

 

[dgillz]

Try this:

{table.date} in dateadd("m",-12,currentdate) to {?ParameterDate}

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"making predictions is tough, especially about the future" - Yogi Berra

 

[mitmat]

That's excellent! Thanks dgillz

 

[lbass]

I think that should be:

{table.date} in dateadd("m",-12,{?ParameterDate}) to {?ParameterDate}

-LB

 

[mitmat]

Well spotted Ibass, I thought it was working but I was putting in Todays date derrr.

You're the man..