Year Difference

[Johmz]

Hi,

I need help for the formula on how to compute if the Input date is less than 1 year from today

[dkungu · Accepted solution]

Try to get the difference in months between today and user input date 

[Johmz]

I need to identify the exact date.. Like if today's date is 07/07/2024 then minus 1 year  answer should be 07/07/2023.

[Johmz]

How to convert this in formula

Today's date - 1 year = "mm-dd-yyy"

ex. 07/07/2024 - 1 year = 07/07/2023

[danilang · Accepted solution]

hi @Johmz 

Use 

DateTimeDiff(DateTimeToday(),[Field1],"years")

 Dan