Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Month() needs help
Message
From
16/08/2000 09:03:41
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00405422
Message ID:
00405447
Views:
23
>vfp 3.0
>
>Hello All,
>
>I am trying to do a batch print for example
>
>on the 15th of the month, I would like to print all
>records entered for the previous month.
>
>Have been trying to use month() function with no luck.
>
>Any thoughts? Thanks and have a good day.
>
>Becky


Becky,
You mean how to find start and end of prev. month ?
ldPrevMonStart = gomonth(date()-day(date()),-1)+1
ldPrevMonthEnd = date()-day(date())
or you could say :
lcYearMonPrevMonth = left(dtos(gomonth(date(),-1)),6)
for dtos(DateField) = lcYearMonPrevMonth

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform