3 of 3 people found this helpful
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?
1 of 1 people found this helpful
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.
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.
Please find the below..
Hope above link will help you to create dynamic fiscal month with day....
I have tagged you on the workbook attached. Was having some trouble attaching the workbook here.