Beverly Penney
asked on
How can I query records that are only within the last year using sysdate?
Hi There,
I have a field invoice_date that is a DATE field. I want to be able to select all rows from the table invoice to show customers who have had an invoice within the last 12 months using sysdate. How can this be done?
Thassk,
R
I have a field invoice_date that is a DATE field. I want to be able to select all rows from the table invoice to show customers who have had an invoice within the last 12 months using sysdate. How can this be done?
Thassk,
R
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.