Skip to content
Advertisement

how to check a date is in current financial year

I am trying to check a condition if given date is in current financial year i.e april to march. but not getting any idea how to do

code

irt is date 01-09-2020.

Advertisement

Answer

I think the simplest approach is to offset the date column and sysdate by 3 months, and compare the year part:

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement