I have some problem with datetime in sql server 2005.

In adp project connected to an sql server 2000 when I refer to a datetime
formatting I use something like this:

select * from  aaa where  mydate = '" & me!date & "'"

and all is ok.

In adp project connected to an sql server 2005 when I refer to a datetime
formatting I have to use sometime :

select * from  aaa where  mydate = '" & me!date & "'"

but sometime :

select * from  aaa where  mydate = '" &  format(me!date,"mm/dd/yyyy") & "'"

May be I do something's wrong.

Is there someone who can help me?

Thanks in advance

Marco Dell'Oca
Milan Italy