Hi team,
I have been trying to get year and month difference between two dates. It is possible in excel through datedif() function. However, I am unable to get the same on alteryx. Below is the example:
Any help would be highly appreciated!
Hey @sahelmajid,
Alteryx is optimised to only allow date calculations with date data types. There is a good quick video on data types on the community here: Understanding Data Types - Alteryx Community. To convert your text to date data types I use the date time tool then a formula to calculate the difference and format the values:
The community has some quick and easy videos on formulas and the Formula Tool here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Writing%20...
Any questions or issues please ask
Ira Watt
Technical Consultant
Watt@Bulien.com
Thank you so much! That helps. Just curious, what if we want to add days to it as well?
Can we do that as well with alteryx workflow?
@sahelmajid that is an interesting one, I haven't been able to figure out how to add leap days into the calculation which I assume is what is throwing off the number of days:
Always find these fun and was definitely a little trickier than I first anticipated so decided to have a little stab! If there's any issues when you try applying this to a larger dataset then let me know and I can revisit the logic.
Obviously you can trim out the actual Years/Month/Days fields with a Select tool afterwards if you don't want them hanging around, or can even compress all of the expressions into one if you don't mind playing around and ending up with a single, mammoth statement.
