Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Function to get the last day of month
Message
From
12/07/1997 12:00:54
 
 
To
12/07/1997 11:36:40
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00039619
Message ID:
00039673
Views:
43
>>Hi! Jim!
>>
>>you can try the following:
>>
>>ldDate = {31.03.97}
>>lcSeparator = substr(dtoc(ldDATE),3,1)
>>ldBegDate =CTOD([01]+lcSeparator+substr(dtoc(ldDate),4))
>>ldEndDate = gomonth(ldBegDate,1)-1
>>
>>May be it be it not so short but it always return correct result...
>
>It will work as long as the year is not the first part.

It will work as long as the day is the first part. :)

Vlad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform