Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Date value from year, month and day numbers in VFP5
Message
De
24/08/2001 12:55:07
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00548656
Message ID:
00548797
Vues:
10
This message has been marked as a message which has helped to the initial question of the thread.
>>VFP6 has a function that returns a date from year, month and day numbers - i.e. DATE(1998,2,28) will return 02/28/1998. Is there a better way in VFP5 than to build a date string from the values and pass it to the CTOD function?
>
>Ernest,
>
>I can't recall for sure, but I think that VFP 5.0 did support the strict date syntax for expressing dates. IOW {^2001/8/24}. If so, all you'd need to is use evalute this in a string.

Yes confirm :)
ctod(transform(lnYear*10000+lnMonth*100+lnDay,'@R ^9999/99/99'))
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
Répondre
Fil
Voir

Click here to load this message in the networking platform