Same date last year/quarter

[#1]

what expression would I use to find the same date, but last year or quarter? My best guess would be

Today()-quarter

Today()-year

[Michiel_QV_Fan]

addyears(today(), -1) will give you the previous year date

addyear(today(), -1, ceil(month(today()/3) will give you year and quarter

[#3]

thanks Michiel

how about just last quarter though, instead of last quarter and year?

[Michiel_QV_Fan]

ceil(num(month(addyears(today(), -1))/3) as Quater_lastYear

[#5]

So currently I have a line in my master calendar which flags if a date is in the last quarter to date.

inquartertodate (Feedback.TempDate,'2013-11-14',0) *-1 as Feedback.LQTDFlag

Obviously the problem with this is that I have to change the date manually each day. I tried insert your suggestion in place of '2013-11-14' (as per below) but i got an error

inquartertodate (Feedback.TempDate,ceil(num(month(addyears(today(), -1))/3),0) *-1 as Feedback.LQTDFlag

what am I doing wrong?

[Michiel_QV_Fan]

You have a calculated quarter in the basedate. This should be a date.

Try this:

inquartertodate (Feedback.TempDate,today(),0) *-1 as Feedback.LQTDFlag

[#7]

That gives me the current quarter to date unfortunately. I actually need the last quarter to date

[Michiel_QV_Fan · Accepted solution]

inquartertodate (Feedback.TempDate,addmonths(today(), -3),0) *-1 as Feedback.LQTDFlag

[#9]

PERFECT! thanks