I am running MS SQL 7 SP4. Recently I have added a new user with default language of British English. Problem arise when I do isDate([Time_Stamp]) which return false on date format of YYYYMMDD, but YYYYDDMM was accepted.

Things went well after I changed the default language to English, YYYYMMDD was accepted again.

Any idea what causes this?