Using Now() function is access projects

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

Julius Montgomery

In access 2002 queries I have been using "Now()-[oldate]"
to calculate date fields. I am upsizing my queries to
sql, but now this function does not work. Please advise
of the correct function to use.

Thanks
 
Dear Julius:

An equivalent for Now() is GETDATE(), or possibly GETUTCDATE(), which
is really great for systems where users may be entering data from
different time zones.

A big difference is that, while Now() uses the local time of the
workstation, the SQL Server functions use the time of the server. So
a user located in a different time zone from the server will NOT have
the same results this way. Working with users in different time zones
has always been complex. Not something to be done without a bit of
thought.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top