Hi,
Is there a function in Oracle to derive the week_number based on fiscal calendar start date.
Our FY21 stats from 27-Dec-2020.
So 27-Dec-2020 to 2-Jan-2021 is week-1.
It's always Sun-Sat week.
i.e Fiscal year always starts on Sunday.
Next year it will be from 26-Dec-2021 to 01-Jan-2022 week-1.
How can we derive the week based on the input_date using above fiscal calendar.
The Fiscal year start_date is defined in Oracle GL period tables. So we know when the year begin along with fiscal months.
thanks for your input.