Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
First Saturday Of Fiscal Month
Message
De
10/02/2010 13:28:52
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
01448576
Message ID:
01448590
Vues:
37
>>>>>>>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.

Each quarter has 13 weeks, 4 quarters make 52 weeks or a year
Gregory
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform