Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
First Saturday Of Fiscal Month
Message
 
 
To
10/02/2010 13:20:22
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
01448576
Message ID:
01448588
Views:
42
>>>>>>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

Honestly, I didn't get what 4-4-5 mean.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform