Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CTOT() inconsistent?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00838159
Message ID:
00838170
Views:
21
>I'm running VFP8 SP1 and VFP7 SP1. Depending on the format passed in, VFP may expect a 'T' in the datetime format. Seems odd to me.
>
>?CTOT('2003-10-21 00:00:00')
>yields an dempty datetime
>
>?CTOT('2003-10-21T00:00:00')
>yields the correct datetime
>
>?CTOT('10/21/2003 00:00:00')
>yields the correct datetime
>
>?CTOT('10/21/2003 00:00:00')
>yields an empty datetime

Adding to what Sergey said, the first will yield the correct date and time if you add ^ as the first character, indicating that it's a strict date time format.
George

Ubi caritas et amor, deus ibi est
Previous
Reply
Map
View

Click here to load this message in the networking platform