Need help, query syntax

[vidus]

Hey guys,

I am creating an adp on sql. One of my old queries doesnt work in the new adp.

The criteria is >=Date() And <=Date()+15 which finds all the jobs due within 2 weeks of todays date from our DueDate field.

Anyone have any idea what the new syntax would look like?

 

[pbaldy]

The closest comparable function in SQL Server is GETDATE(). It returns the time as well, like Now() does in Access, so you may want to use the CONVERT() function along with it. More info on both in BOL (Books Online, which is SQL Server's help). If you're not familiar with it, you need to be.