Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Month() needs help
Message
De
16/08/2000 09:03:41
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00405422
Message ID:
00405447
Vues:
24
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform