Need help on Dates w.r.t 13 months ,25 months

[abubakarsiddiq7]

hi experts ,

i have a requirement on dates 

Requirement : I have two date columns "repotted on date" and "effective date " when i select Reporeted on date on UI then i need to show 13 months sales from effective date 

Example: when i select  "repotted on date"= '01-AUG-21' then data should show effective_date between '01-Aug-19' and '31-Jul-20' sales .

Thanks in advance ....

Thanks,

Siddiq

[abubakarsiddiq7]

any help on the above requirement