Date time quarter end expressions

Hi - I have a date 12-11-2017. What would the expression be to return the start and end of the quarter? I am primarily focused on getting the quarter end for any given date, but could see having the beginning helpful too. Thanks!

Input:

12-11-2017

Output:

Start: 10/1/2017

End: 12/31/2017

Expression

Accepted answers

jdunkerley79

Assuming you have the date as an Alteryx date I suggest:

Start of Quarter:

Left([Parsed],5) +
PadLeft(ToString(Ceil(DateTimeMonth([Parsed])/3)*3-2),2, '0')
+ '-01'

End of Quarter:

DateTimeTrim(Left([Parsed],5) +
PadLeft(ToString(Ceil(DateTimeMonth([Parsed])/3)*3),2, '0')
+ '-01', "lastofmonth")

Sample attached

Quarters.yxmd

All comments

jdunkerley79

Assuming you have the date as an Alteryx date I suggest:

Start of Quarter:

Left([Parsed],5) +
PadLeft(ToString(Ceil(DateTimeMonth([Parsed])/3)*3-2),2, '0')
+ '-01'

End of Quarter:

DateTimeTrim(Left([Parsed],5) +
PadLeft(ToString(Ceil(DateTimeMonth([Parsed])/3)*3),2, '0')
+ '-01', "lastofmonth")

Sample attached

Quarters.yxmd

cireost

awesome. thank you!

to follow up with an add on question, do you know if there is a way to calculate the # of days in a quarter?

so if its 3/31, 6/30,etc. - is there an expression to calculate how many days are in that quarter?

thanks!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703