Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
The beginning of a quarter
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Divers
Thread ID:
01373480
Message ID:
01373493
Vues:
20
This message has been marked as the solution to the initial question of the thread.
Try (not tested much)
lnQuarterBegin = DATE(YEAR(ldDate), (QUARTER(ldDate)-1)*3 + 1, 1) 
>
>
>I have a date and i want the beginning of a quarter.
>
>eg1 = 01/01/2009
>eg2 = 23/02/2009
>eg3 = 15/04/2009
>
> beginning of a quarter( eg1 )
> beginning of a quarter( eg2 )
> beginning of a quarter( eg3 )
>
>
>01/01/2009 Give 01/01/2009
>23/02/2009 Give 01/01/2009
>15/04/2009 Give 01/04/2009
>
>
>
>thank in advance
>
>bernhart
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform