datetime in adp connected to an sqlserver 2005 database

  • Thread starter Thread starter giorgio rancati
  • Start date Start date
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
 
Back
Top