Home » Developer & Programmer » Reports & Discoverer » date (disc 10.1.2)
date [message #310860] Wed, 02 April 2008 12:16 Go to next message
Messages: 235
Registered: December 2007
Location: USA
Senior Member
I have a report in which you have a field called " selection date". My question is how to get the records " where the selection date is 12 months less than the present date". Please any advice is greatly appreciated.

Re: date [message #310893 is a reply to message #310860] Wed, 02 April 2008 14:08 Go to previous message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Use the ADD_MONTHS function, such as
FROM your_table
WHERE selection_date >= ADD_MONTHS(sysdate, -12);
Previous Topic: Losing records
Next Topic: Report to Excel Conversion
Goto Forum:

Current Time: Sat Aug 19 02:37:58 CDT 2017

Total time taken to generate the page: 0.11131 seconds