Difference of Year and month data

[SH_94]

Hi community,

I would like to ask how do we minus the date format below :

Thank you.

[ShankerV]

Hi @SH_94 

This can be achieved with the help of formula tool.

Use datetimeparse to covert to alteryx format and then use datetimediff() to find the months diff.

Many thanks

Shanker V

[ShankerV]

Hi @SH_94 

Please find the expected output.

datetimediff(datetimeparse(tostring([YearMonth1]),"%y%m"),datetimeparse(tostring([YearMonth2]),"%y%m"),"months")

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[SH_94]

Hi @ShankerV ,

Can i have the wokflow ? As i want to see the setting of datatype/

[ShankerV]

Hi @SH_94 

The below is the setting of the datatype.

Couldn't save the workflow as the below error is prompted.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @SH_94 

If your datatype is string already, the below formula will work.

datetimediff(datetimeparse([YearMonth1],"%y%m"),datetimeparse([YearMonth2],"%y%m"),"months")

Many thanks

Shanker V

[ShankerV]

Hi @SH_94 

Hope this helps!!!!

datetimediff(datetimeparse([YearMonth1],"%y%m"),datetimeparse([YearMonth2],"%y%m"),"months")

Many thanks

Shanker V