Hi, I need your help in calculating financial weeks based on below rules: if there are 3 or more working days (Monday to Friday) in the last week of June then it is week 53 if there less than 3 working days in the last week of June then it is week 1 in the next financial year. 3.My calendar starts from year 2012. I appreciate your help.

Create a "calendar table" and calculate this once. Then you can use it for your query. See: https://weblogs.sqlteam.com/dang/2010/07/19/calendar-table-and-datetime-functions/

Calculating financial week in SQL

sabb 1

Hi,
I need your help in calculating financial weeks based on below rules:

if there are 3 or more working days (Monday to Friday) in the last week of June then it is week 53
if there less than 3 working days in the last week of June then it is week 1 in the next financial year.
3.My calendar starts from year 2012.

I appreciate your help.

LiHong-MSFT 10,046 Reputation points

2022-01-17T06:31:15.613+00:00

Hi,@sabb
Is the first day of a week Sunday or Monday?
And the calendar starts from 2012.1.1 or the last week of June in 2012?
sabb 1 Reputation point

2022-01-17T06:50:02.63+00:00

Hi @LiHong-MSFT ,

The first day of the week is Monday. The calendar starts from 2012.1.1.

1 answer

Tom Phillips 17,716 Reputation points

2022-01-17T13:13:08.293+00:00

Create a "calendar table" and calculate this once. Then you can use it for your query.

See:
https://weblogs.sqlteam.com/dang/2010/07/19/calendar-table-and-datetime-functions/
Please sign in to rate this answer.
sabb 1 Reputation point

2022-01-18T04:27:32.18+00:00

I do have calendar table. I am not sure if the article in the link you have provided is help me.
It does a lot of calculation, but nothing close to my requirement.
Thanks for your help.
Sign in to comment