Last 4 quarters from DateTimeNow()

I'm having a hard time trying to produce the last 4 quarters from DateTimeNow(). I'll have to use the 4 quarters in the column name and also as a counter.

I found this in our community:

IF ceil(DateTimeMonth(DateTimeNow())/3)!=1 then

'Q'+tostring(ceil(DateTimeMonth(DateTimeNow())/3)-1)+tostring(DateTimeYear(DateTimeNow())-2000)

else 'Q4'+tostring(DateTimeYear(DateTimeNow())-2000-1) endif

But it doesn't work well past the previous quarter.

Any help would be appreciated.

Date Time

Accepted answers

JosephSerpis

Hi @LudwigB I mocked a workflow that I think produces the output you describe. Let me know what you think?

Quarters_240919.yxmd

All comments

BrandonB

What about parsing the month out from your date and using the following?

IF [2]>=1 AND [2]<=3
THEN "Q1"
ELSEIF [2]>=4 AND [2]<=6
THEN "Q2"
ELSEIF [2]>=7 AND [2]<=9
THEN "Q3"
ELSEIF [2]>=10 AND [2]<=12
THEN "Q4"
ELSE Null()
ENDIF