Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
First Saturday Of Fiscal Month
Message
 
 
À
10/02/2010 13:20:22
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
01448576
Message ID:
01448588
Vues:
39
>>>>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform