V
Vinod
Hi All,
I've been developing some access databases. I'm storing dates in my local
(Access) database, some tables with dd-mm-yyyy and dd-mmm-yyyy format. When
I'm generating reports with user input dates (using date control) in the form
some times it is working but not some times.
Requirement: Retrieve bookings data from 10-Feb-2009 to 02-Mar-2009.
My dynamic query looks like this Bookings_Date>=10/02/20009 and
Bookings_Date<=02/03/2009.
But the data is not retreiving accordingly. i.e., its treating as
02-Oct-2009 and 03-Feb-2009.
I've faced the above situation when the regional setting was in US format.
In UK regional setting its working well.
If I'd like to create a query to work for all types of regional settings
what needs to be done?
Please share your thoughts and ideas which will be appreciated.
Advanced Thanks
Vinod
I've been developing some access databases. I'm storing dates in my local
(Access) database, some tables with dd-mm-yyyy and dd-mmm-yyyy format. When
I'm generating reports with user input dates (using date control) in the form
some times it is working but not some times.
Requirement: Retrieve bookings data from 10-Feb-2009 to 02-Mar-2009.
My dynamic query looks like this Bookings_Date>=10/02/20009 and
Bookings_Date<=02/03/2009.
But the data is not retreiving accordingly. i.e., its treating as
02-Oct-2009 and 03-Feb-2009.
I've faced the above situation when the regional setting was in US format.
In UK regional setting its working well.
If I'd like to create a query to work for all types of regional settings
what needs to be done?
Please share your thoughts and ideas which will be appreciated.
Advanced Thanks
Vinod