No "LastFullQuarter" in Select Expert

[DataDog]

I'm trying to set up a quarterly CE8.5 recurring report. That's the easy part. The problem is in CR8.5 in that there is no Period "LastFullQuarter" in the Select Expert. Is there an easier way than setting up formulas that say "If today is 1/1/2003 then TransactionMonth = 10,11,12 and TransYear = CurrentYear-1 else if Today is 4/1/2003..."

Thanks in advance for your help

 

[goranm]

Hi !

One way to get the last three full month is to use a Record Selection and write like this:

{YourDate} >= date(year(dateadd("m",-3,currentdate)),month(dateadd("m",-3,currentdate)),1 ) and
{YourDate} <= date(year(currentdate),month(currentdate),1)-1

/Goran

 

[Naith]

There are Calendar1stQtr to Calendar4thQtr commands in 8.5

 

[DataDog]

Hi Goran:

Your formula worked like a charm!

Thanks!