Access Project Date Functions

[Julius Montgomery]

I am upsizing an access 2002 query to sql. In 2002 I used
the following string to add/subtract dates "Now()-

.
[oldate] with great success. In sql this string will now
work. Please advise.

Thanks

 

[Van T. Dinh]

Now() is a VBA function so it won't work in MS-SQL. You will need to use
the T-SQL GetDate() function.

Check MS-SQL Book-On-Line (BOL, basically, a must for MS-SQL Server
Back-End) for more info.