date/time comparsion with sql locale setting problem
Posted on 2004-08-01
I am writing an application with vb6 and access 97
I pass query which will compare the database's date/time with the current date/time. eg:
SELECT (CAExpiry - #" & Now & "#) AS ToBeExpired, FROM CompanySearch
But my users will use different language and have different locale setting for date/time
So, some users have error with the query
I would like to ask what is the safest way to make sure different setting of locale can use my program?