Data Wizard -Search Criterea

rbuser

When searching on a date filed how can I, for example, use current_date
minus 3 months.

Ken

nicocizik

Hi Ken,

Depending on which database server you are using, you may be able to use the
ADD_MONTHS() built in method. I know for sure this method is available in
SQL Server and Oracle. You may need to check your current database's help
file to see if this is supported. Something like the following...

SELECT ADD_MONTHS(HireDate, -3) FROM Employees

--

rbuser

Thanks, I will try this.

Ken