Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DATE BUG ????
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00329861
Message ID:
00331474
Views:
18
As Jim has said, THIS IS NOT A BUG! VFP interprets date literals based on the value of SET DATE. If you have SET DATE AMERICAN then what is inside the {} must correspond to American date formats, namely MM/DD/YYYY. If you have SET DATE BRITISH then what is inside the {} must correspond to British date formats, namely DD/MM/YYYY. This also applies to CTOD - the string must be in the format that corresponds to SET DATE.

>Hi again !
>
>The main bug is when you use quotation like this - {}
>in this case FoxPro understand as American format, but you can
>use function like this - ctod('31/01/2000') main to use this function, not using - {}
>
>P.S. Mr Jim Booth gave to you good advice too ...
Rick Borup, MCSD

recursion (rE-kur'-shun) n.
  see recursion.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform