set language us_english
set dateformat mdy
set datefirst 7


if you use:

'yyyymmdd 00:00:00'

you have an independent format from the language setting.

For datefirst the problem is different.

Check your VFP Options setting,
VFP SP1 have reset it to American ?

Fabio