Why does SQL change in the QEB

[paulmcdonnell]

Hi guys...

Similar to my earlier problem...

If I put the following SQL into a QEB

SELECT Data_Basedata.* FROM Data_Basedata WHERE (((Data_Basedata.Surname) Is Not Null) AND ((Data_Basedata.promdate)=#12/17/2001#));

The QEB changes the date 12/17/2001 to #17/12/01#...

Why?

Cheers
Paul

 

[paulmcdonnell]

I THINK that I just solved this myself by setting the format:


AND (Data_Basedata.promdate)= #" & Format([Forms]![Form-basedata-quick-update].[control1], "mm/dd/yy") & "#")

Cheers

 

[Jack Cowley]

FYI - Access SQL statements require the date to be in US format. Take a look at this article for a solution to this requirement.

http://support.microsoft.com/default.aspx?scid=kb;en-us;q210069