God Dam Americans only kidding !American Date problem

[Chance1234]

For as long as time can remember i have had an Access 97 Db with a module in it, part of the code in the module is the following

strSql = "SELECT * FROM TBLHISTORY WHERE dateofchange =#" & Date & "#"
Set MyreC = Mydb.OpenRecordset(strSql)

never ever had any problems with it until now , for some strange reason im getting the date in american format,

nothigns changed and my regional settings are english so why has this suddenly happend ?

can anyone help ?


Chance

 

[cmurray78]

yes your regional settings is english ... but whos english, remember that america also speaks english.
you can specify the date format you want by clicking the date tab in the regional settings diaog box or changing your locale to english(Jamaica). this works if you are running Windows 2000 i think it work in earlier versions too.

CAM