Access Project Date Functions

  • Thread starter Thread starter Julius Montgomery
  • Start date Start date
J

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
 
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.
 
Back
Top