Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 :)