Chance1234
IS-IT--Management
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
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