Hi,
I need help for the formula on how to compute if the Input date is less than 1 year from today
Try to get the difference in months between today and user input date
hi @Johmz
Use
DateTimeDiff(DateTimeToday(),[Field1],"years")
Dan
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.
How to convert this in formula
Today's date - 1 year = "mm-dd-yyy"ex. 07/07/2024 - 1 year = 07/07/2023
