In my quick report I'd like to select a date range going back to the first of last year, so for today, 2/26/2020 it would select 1/1/2019 - today.
date_entered between sub_months(trunc(sysdate, 'YEAR'), 12) and trunc(sysdate, 'YEAR')-1/24/60/60
I tried a sub_month but that didn’t work. I’m already using this format for going forward one year:
OP_START_DATE between trunc(sysdate, 'YEAR') and add_months(trunc(sysdate, 'YEAR'), 12)-1/24/60/60
In my quick report I'd like to select a date range going back to the first of last year, so for today, 2/26/2020 it would select 1/1/2019 - today.
date_entered between sub_months(trunc(sysdate, 'YEAR'), 12) and trunc(sysdate, 'YEAR')-1/24/60/60
I tried a sub_month but that didn’t work. I’m already using this format for going forward one year:
OP_START_DATE between trunc(sysdate, 'YEAR') and add_months(trunc(sysdate, 'YEAR'), 12)-1/24/60/60
Maybe this could work?
SELECT date_entered
FROM your_table
WHERE reported_date BETWEEN ADD_MONTHS(TRUNC (SYSDATE,'YEAR'), -12) AND SYSDATE
ORDER BY date_entered ASC
Thanks, Anmise; that worked!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.