Page 1 of 1
Adding 365 days to date field
Posted: Thu Sep 15, 2011 5:51 pm
by vandeboy
My SQL database has a date field named _RenewalDate_ and I need some help creating calculation field so that if the _RenewalDate_ is less then _Today_s_ date the report will print the _RenewalDate_ + 365
=> RE: Adding 365 days to date field
Posted: Fri Sep 16, 2011 10:02 am
by philpaul
You might try something like this:____iif(RenewalDate<DATE(),ADDYRS(RenewalDate,1),RenewalDate)____I used "ADDYRS" instead of using "RenewalDate + 365" because some years (leap years) have 364 days.____- Phil