Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dr223
Constraint Violating Yak Guru
444 Posts |
 Posted - 2010-03-31 : 05:43:39
|
| Hi, How Can I change this code from access to sql server 2005; WHERE (((tblProjectScheduleEv.EvBFDate)<=Date())Thank you in advance |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-03-31 : 05:50:08
|
| WHERE tblProjectScheduleEv.EvBFDate <= GetDate()There are 10 types of people in the world, those that understand binary, and those that don't. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-03-31 : 06:04:34
|
| Is EvBFDate having time part too?WHERE tblProjectScheduleEv.EvBFDate < dateadd(day,datediff(day,0,GetDate())+1,0)MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Code Change