hi
I am using a calender object for a user input. The user will input a date, for which a report will be generated based on that date as a criteria.
This database is placed in the server for many people to access. Problem is, the user's PC have different data settings (under the regional and language setting), example: 2/11/04 and 11/2/04 for 11 feb 2004
This results in different query outcome for different users. How can i correct this without having to set all the users PC to a particular date setting?
Cheers
Sam
I am using a calender object for a user input. The user will input a date, for which a report will be generated based on that date as a criteria.
This database is placed in the server for many people to access. Problem is, the user's PC have different data settings (under the regional and language setting), example: 2/11/04 and 11/2/04 for 11 feb 2004
This results in different query outcome for different users. How can i correct this without having to set all the users PC to a particular date setting?
Cheers
Sam