Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find last date in a month
Message
From
22/01/2007 20:05:34
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01187758
Message ID:
01187950
Views:
15
>>Borislav,
>>
>>Try with {^2006/01/30}
>>
>>Since every month has a first, go back to the first of the month, add one month, subtract one day
>>
>>?gomonth(m.d+1-day(m.d), 1) -1
>>
>
>
>After Dragan's posting I realize that (That happens when I post messages only from top of my memory) Check my answer to Dragan for correct function (I use it very successful :-))

THAT is one of the reasons why it pays to have a LastDayOfMonth function. Even something this simple can cause mistakes. Encapsulate the knowledge in that function once and for all.
Previous
Reply
Map
View

Click here to load this message in the networking platform