Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Function to get the last day of month
Message
De
12/07/1997 11:36:40
 
 
À
12/07/1997 04:15:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00039619
Message ID:
00039670
Vues:
40
>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.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform