Re: datetime in adp connected to an sqlserver 2005 database "giorgio rancati" <giorgio_No_Spalmer_rancati[ at ]tiscali.it> 23.02.2006 01:47:28 Hi Marco, you can use the iso format ---- select * from aaa where mydate = '" & format(me!date,"yyyymmdd") & "'" ---- the iso format is indipendent from client and server localization bye -- Giorgio Rancati [Office Access MVP] "Mark" <dmsoftware[ at ]tin.it> ha scritto nel messaggio news:43fcef18$0$5987$4fafbaef[ at ]reader2.news.tin.it... [Quoted Text] > 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 > > >

datetime in adp connected to an sqlserver 2005 database "Mark" <dmsoftware[ at ]tin.it> 23.02.2006 08:01:13 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