Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The beginning of a quarter
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Miscellaneous
Thread ID:
01373480
Message ID:
01373493
Views:
23
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform