Date format puzzle.

[JMM]

The following code is supposed to show date in a search function.

strSearch = "[" & fld.Name & "] = #" & Me.Date & "#"

It sort of works but not correctly. My date format is UK ie. dd/mm/yy. If I enter dd/mm/yy into the 'Search for' box it says there are no records. However if I enter mm/dd/yy it finds records where the date actually is dd/mm/yy. The machine's settings is for dd/mm/yy and the data is entered in this format.
What is wrong with the code. Any ideas.

 

[MangroBongacello]

JMM,

you always have to use mm/dd/yy format in queries, regardless of everything. Try this:

strSearch = "[" & fld.Name & "] = #" & Format("mm/dd/yy",Me.Date) & "#"

Hope it helps.
Mangro

 

[mymou]

Hi all

This is a problem for dates and currencies as far as i can tell.

Got in contact with Dr International (Microsoft) re this issue and they stated that 'you can not avoid reformatting the data'.

Here is a site they set me to for guidelines for Transact-SQL:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_14_3unn.asp

Stew