>Mark,
>
>The SET DATE setting at the time the code is compiled controls the interpretation of date literals. If the prg was compiled with SET DATE BRITISH then the date literal would be compiled as Day,Month,year. If it was American then month,day,year. The safe way to prevent this setting from having any effect on your code is to use the strictdate format for your date literals, {^1999/12/01}. Begin the literal with a caret ^ and then use year, month, and day. This method of specifying a date lteral is not affected by the SET DATE setting.
>
>This format for dates works in VFP 5 even though it is not documented in VFP 5.
FYI, it is documented in VFP5. It's in the StrictDateEntry property.