>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)