We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Problems with Date Time Difference

6 - Meteoroid

The following function results in the date difference of 0. I would expect that this would result in a date difference of 1. What is causing this issue? This seems to work with any other month difference with the exception of January and February month ends. These hard coded dates shown here are replaced with formulas in the actual data that I am working with. 



19 - Altair
19 - Altair
Did you try a data type of int16?
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Please Subscribe to my youTube channel.
13 - Pulsar



It's because of how that function compares the two date values to output the difference. Image below is from help site and looking at the part highlighted, the day on the end date (first value) has to pass the start date. Since this won't happen in Feb, the month won't add until it goes to the next day.


One way that you can ensure that month diffs are always progressing is to trim your date values to the first of the month. Below is a formula that would give you the output you're looking for.


Hope this helps!



6 - Meteoroid

This fixed the problem. Thanks!