Date & Time Query

[E_Gold]

hi

if my computer region set to dd/MM/yyyy hh:mm and my query in access:

select * from MyTbl where MyDate between #25/12/2010 10:51# and #30/12/2010 12:11#

is this query will work on computer that his region set to MM/dd/yyyy hh:mm ?

if no, how to fix it without change the region in the computer ?

thank's in advance

 

[stopher]

If you're just using SQL you don't need to worry about the region. It should interpret the date as the local region. However, if you are using VBA then you will need to present the date in US format. You can use the FORMAT function to do this:

Format("25/12/2010 10:51","mm/dd/yyy hh:nn")

hth
Chris

 

[Galaxiom]

I would encourage developers to move to ISO date format (YYYY/MM/DD) in code because it is completely unambiguous regardless of the system date format.

I also prefer to Format with the date delimiters included rather than concatenating them.

Format(somedate, "\#yyyy/mm/dd hh:nn\#")

 

[E_Gold]

thank's for the help