The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

DateTimeQuarter

Good morning!

 

This may be a very simple thing, but would it be possible to add a DateTimeQuarter() function? We have DateTime Second, Minute, Day, Month, and Year, and being able to have an easy formula for the quarter as well would be incredibly convenient. 

 

Thanks,

Kat

3 Comments
rbelski
6 - Meteoroid

The following instructions appear in Alteryx Help under release 2024.1, but I don't see any discussion in Community except this post.

DateTimeQuarter

DateTimeQuarter(dt, [Q1Start]: Returns the numeric value for the quarter of the year in which a date-time (YYYY-MM-DD) value falls. Use the optional numeric parameter to indicate the start month for the first quarter (Q1).

at "https://help.alteryx.com/current/en/designer/functions/datetime-functions.html#datetime-functions-65..."

kcoonrod02
6 - Meteoroid

It looks like with the 2024.1 release, this has been added! Designer 2024.1 Release Notes (alteryx.com)

NicoleJ
Alteryx
Alteryx
Status changed to: Implemented

Comments correct! This was added in 24.1 release :)