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

Add interval Types to the DATETIMEDIFF function

I have reviewed a number of batch macros that work well for mirroring the "NetworkingDays" excel calculation but it would be great to add an interval type for "weekdays" to the DateTimeDiff formula ie

 

 DateTimeDiff ( [Date01],[Date02], "WorkDays")  where any Saturday or Sunday between the dates would be discounted.

7 Comments
BenG
Alteryx Alumni (Retired)

Thanks for the request.  This would be a good addition to the DateTimeDiff formula.  We will consider it for a future release.

 

Best Regards,

Ben

BenG
Alteryx Alumni (Retired)
Status changed to: Under Review
 
SeanAdams
17 - Castor
17 - Castor

The dateTimeDiff function is another that uses different codes for parameters than other date functions or capabilities.

 

I've created a suggestion to refactor the way that DateTime handling works, to make this consistent, more capable and user-friendly.    https://community.alteryx.com/t5/Alteryx-Product-Ideas/Refactor-Date-time-treatment/idi-p/46420

 

If we add the DateTimeFormat; DateTimeDiff and other date-time functions to this - and create a formula builder that allows you to build formulas quickly without having to know the magic codes - it takes yet another barrier out of peoples's lives and makes the tool much more approachable.

ck_dup_428
6 - Meteoroid

It would also be good to have "weeks" as an interval type, as well as an option for fractional results, e.g. 1.5 years, 0.3 months, etc.

KylieF
Alteryx Community Team
Alteryx Community Team
Status changed to: Revisit

Thank you for your idea! Our product team has reviewed this idea and cannot place it on the road map at this time. However they would still like to keep it in mind for future road map decisions. We'll update the status of this idea once we are able to term where or if we can place it on the road map.

patrick_digan
17 - Castor
17 - Castor

This would be a nice add!

NicoleJ
Alteryx
Alteryx
Status changed to: Accepted

Given some of the nuances of what is considered a "work day" in different cultures, industries, etc., we will likely pursue this related idea to address the NetWorkDays use case with a direct function instead (so that additional parameters can be provided): https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/Business-Days/idi-p/297917