7 Replies Latest reply on Apr 18, 2017 7:04 AM by seeta t

# How to identify 3rd Saturday within a month?

Hi All,

Is there any way to extract 3rd Saturday of each month from Date field by using a calculated field?

For example: Feb 3rd Saturday is 18th in 2017, but in 2018 Feb 3rd Saturday is 24th.

I want to create Fiscal months starting from 1 to 12 where First month should display the date starting from 18th Feb 2017 to 25th March 2017 which is 4th Saturday of March.

For Year 2018,  date starting from Feb 24th(3rd Saturday) to March 31st which is 4th Saturday of March.

Thanks.

• ###### 1. Re: How to identify 3rd Saturday within a month?

Hi Kamal,

I'm not sure this will help you with your end goal, but here's one way to determine the 3rd Saturday of each month.

The 3rd Saturday (or any other day of the week, for that matter) will always occur on the days of the month 15-21. So if you have a date field,

Day([Date])>=15 AND Day([Date])<=21 AND DATENAME('weekday',[Date])="Saturday"

will return true only for the 3rd Saturday of every month.

Does that help?

Michael

3 of 3 people found this helpful
• ###### 2. Re: How to identify 3rd Saturday within a month?

Hi Michael,

Thanks for your reply.  This helped me to determine the third Saturday of each month. In the same way, I need to identify the 4th Saturday so that I can create a Fiscal month starting from 3rd Saturday of February to 4th Saturday of March.

1 of 1 people found this helpful
• ###### 3. Re: How to identify 3rd Saturday within a month?

Hi Kamal,

I have built a logic through which you can derive both 3rd and 4th Saturday. Below is the reference. Do let me know if this is useful?

Regards,

Saumya Shetty

1 of 1 people found this helpful
• ###### 4. Re: How to identify 3rd Saturday within a month?

Hi Saumya,

Thanks for your reply. It will be useful for me to create a range from 3rd Saturday of 1st month to 4th Saturday of next month.

Could you please share the logic or workbook so that I can try it from my end. Thanks.

• ###### 5. Re: How to identify 3rd Saturday within a month?

Hi Kamal,

https://www.interworks.com/blog/estam/2015/11/13/creating-custom-fiscal-year-calendars-tableau

Sravan.

• ###### 6. Re: How to identify 3rd Saturday within a month?

Hi Kamal,

I have tagged you on the workbook attached. Was having some trouble attaching the workbook here.

Regards,

Saumya Shetty

• ###### 7. Re: How to identify 3rd Saturday within a month?

H i

Find the sample calculations  as below.

Hope it helps you

Regards

Seeta