Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
First Saturday Of Fiscal Month
Message
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
01448576
Message ID:
01448586
Views:
45
>>>>>I have a fiscal calendar that starts on March 1, and uses 4-4-5. I need to determine the first saturday of each fiscal month.
>>>>>
>>>>>Anyone have a function/proc to do this?
>>>>
>>>>You got your answers yesterday.
>>>
>>>No I didn't. That was a different question.
>>
>>If each fiscal month starts on the first date of the month, then what is the difference between first Saturday of the fiscal month and first Saturday of the calendar month?
>
>Reread my post. I said the CALENDAR starts on 3/1. I didn't say a fiscal month starts on the first saturday. It's determined by the 4-4-5 sequence.

When you have the first saturday of march, can't you add 4 weeks to get to april, then add another 4 to get to may, and another 5 to get to june

Then repeat the 4-4-5 three times
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform