we have a date dimension table where all the calendar and fiscal dates for 30 years are populated. Now we need to add new column as Fiscal_day_date and our Fiscal year starts from Sep-01. we need output as mentioned below :
0 Answers
Related
we have a date dimension table where all the calendar and fiscal dates for 30 years are populated. Now we need to add new column as Fiscal_day_date and our Fiscal year starts from Sep-01. we need output as mentioned below :