Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Month() needs help
Message
 
To
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:
00406033
Views:
25
Thanks for your replies, I will give them a try.

Becky


>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform