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

Click here to load this message in the networking platform