Date Function

[#1]

I have a 'create_date' field and have to find if my create date is 30 months older than current date and also calculate how many days left until its 36 months old.How do I achieve that?

[nagaiank · Accepted solution]

Today() > AddMonths(create_date,30)  will return true (-1) if create_date is older than 30 months

AddMonths(create_date,36) - Today()  will return number of days left until 36 months