Skip to Main Content

SQL & PL/SQL

Anniversary Dates Between Two Periods

User_OK580Aug 30 2021

Hi all,

I am having issues with a query to show anniversaries between two dates. I have the below query to show the anniversary date:
SELECT
add_months(start_date,(EXTRACT(YEAR FROM TO_DATE('&TO_DATE','DD/MM/YYYY')) - EXTRACT(YEAR FROM start_date))*12) as anniversary_date
FROM Table_A

WHERE
add_months(start_date,(EXTRACT(YEAR FROM TO_DATE('31/03/2022','DD/MM/YYYY')) - EXTRACT(YEAR FROM start_date))*12) BETWEEN TO_DATE('01/04/2021','DD/MM/YYY') AND TO_DATE('31/03/2022','DD/MM/YYYY')
I would like to run the report between two dates but when i add the above statement in the WHERE clause it is only showing results for the year 2022 and not the From Date (2021).

Any help is appreciated!

TIA

Comments
Post Details
Added on Aug 30 2021
13 comments
456 views