Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

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.

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,


Alteryx Alumni (Retired)
Status changed to: Under Review

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.


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.


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.