Forum Discussion
Have issue on fiscal week
Hi all, I am having below codes, but it was showing incorrectly for the year when previous year is having 53 weeks. Scenario: I am computing Fiscal Week, where ISO Week starts in July, first Mon...
Instead doing complex "calculation" on the week use better a calendar table for mapping date to fiscal week, see https://www.mssqltips.com/sqlservertip/4054/creating-a-date-dimension-or-calendar-table-in-sql-server/