Getting the past 12 months of data

[ymrs]

This is probably absurdly simple and I am just making it harder than it has to be.

In our ticket system, I have to show the past 12 months of tickets that were closed. I am trying to get a formula that will look at the last 12 full months. These reports run on the first calendar day of each month.

I have a field {CL_CALL_LOGGING.RESOLVE_TIME}; which is a DateTime, that I use for the selection. I have this grouped by month.

These reports are created in Crystal 8.5.

 

[lbass]

Try:

{CL_CALL_LOGGING.RESOLVE_TIME} in dateadd("m",-12,currentdate-day(currentdate)+1) to currentdate-day(currentdate) and
{table.ticketstatus} = "Closed"

-LB

 

[ymrs]

Thank you so much. Worked like a champ!