Formula error

[Sa743liz-]

Hi everyone I'm trying to do this formula below but is not working, can you help me? 

[IraWatt]

Hey @Sa743liz-,

What are you trying to achieve here? If you want to minus one date from another you can use the datetime functions like DateTimeDiff(dt1,dt2,u) which calculates the difference between two dates in days/weeks/months ect...

If your interested in learning more about the datetime functions there is a great cheat sheet Blog here: https://community.alteryx.com/t5/Engine-Works/DateTime-Functions-Cheat-Sheet/ba-p/844353

[binuacs]

@Sa743liz- as @IraWatt mentioned you need to use the datetimediff function here to calculate the days between two dates. Attaching a sample workflow for your reference

[Sa743liz-]

Thank you @IraWatt the DateTimeDiff works but only shows the full number per years. I will need with two decimals like this following ouput: 

This is how it looks at the moment: see below 

[IraWatt · Accepted solution]

Aaahh thats alright @Sa743liz- just do days then divide by 365: