Adding 365 days to date field

[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

[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