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.

YM.xlsx

Common Use Cases

Accepted answers

ShankerV

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

All comments

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

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703