Out of range problem with CurrentDate 1

[JetRamsey]

Works - {TABLE1.FIELD1} < DateTime (CurrentDate - (365 * 20))
Does not work {TABLE1.FIELD1} < DateTime (CurrentDate - (365.25 * 20))

I'm querying a datetime field and trying to give the user the ability to same X amount of years. In this example, 20 years. Thus, I'm using CurrentDate - (365.25 * 20). Unfortunately, the report will accept 365, but not 365.25). Is there another way to calculate X number of years than trying 365.25 * X number of years?

I'm using CR version 14 and viewing an Oracle DB

 

[Charliy]

You can use the DateAdd function.