Datetime quarter

[schenkelpat]

I am trying to build a filter that pulls the Quarter to date sales.  In SQL, I would have done something like:

Date between Datetrunc('quarter', today()) - interval '1 quarter' and datetrunc('quarter',today())

In Alteryx, I've been able to do DateTimeTrim(DateTimeNow(),'month'); but, i can figure out the date time unit to get to quarter?  Is there another way?

Thanks,
Pat

[JordyMicheal · Accepted solution]

Give this a try:

DateTimeFormat([Date],'%Y Q') + ToString(Ceil(ToNumber(DateTimeFormat([Date],'%m'))/3))

[schenkelpat · Accepted solution]

Disregard-figured it out...

CEIL(DateTimeMonth([Calendar Date]) / 3) >= CEIL(DateTimeMonth(DateTimeAdd(DateTimeNow(),-1,"month"))/3)