Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
About the DATE format
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00231431
Message ID:
00235734
Views:
21
>Power,
>
>The delimiters for dates are {} the curly braces. If you are using VFP6 or VFP5 you are best served to specify date constants in teh strictdate format, that is {^1999/06/19} The carot ^ signifies the strict date format, the format is YYYY/MM/DD. Using this format removes any ambiguity resulting from the SET DATE setting.

Hi Jim,

As you are an expert on FoxPro, how does one avoid the ambiguity problem of date formats using VFP3?

To be able to use different values for SET DATE we have been looking at saving dates in Julian Date format when saving dates to character fields, but we need some other way to do it. Do you have any suggestion??

Thanks...

Klas Nygren
(using VFP 3.0 for Win & Mac)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform