Date format problems 1

[dk99]

I have a query which the user inputs the dates into a form in the format "dd/mm/yyyy" yet when I run this through a query it converts the date format to "mm/dd/yyyy" but runs the date as though it is "dd/mm/yyyy"?

EG.

User inputs 01/09/2006, query runs as 09/01/2006 and returns all data from 09 January?


The query is a simple SQL looking at a table and selecting data for the date selected - or it should do!

 

[mp9]

Take a look at

http://www22.brinkster.com/accessory/queries/001.shtml

to address the weirdness of date values in queries.

 

[MichaelRed]

Dates are stored as numeric values, number of days since 12/30/1899 and part of day elapsed as the fractional / decimal part. Formats are semi-controlled by hte international settings, however the SEMI part is important -in particular to queries which ALWAYS uas hte U.S. format for dates.




MichaelRed

 

[dk99]

Thank you mp9 - worked a treat (spent all morning trying to work round it!)

 

[SkipVought]

FYI:

http://support.microsoft.com/kb/130514/

Actually DATE VALUES in ACCESS run from -647,434 (January 1, 100 A.D.) to 2,958,465 (December 31, 9999 A.D.).

DATE VALUES in EXCEL cannot be NEGATIVE and run from 0 (December 31,1899).

Skip,

_[red][/red]