Name
Now Function
Syntax
Now
Return Value
A Variant of subtype Date.
Description
Returns the current date and time based on the system setting.
Example
The following example returns the date 10 days from today:
Dim dFutureDate As Date
dFutureDate = DateAdd("d",10,Now)Programming Tips & Gotchas
It’s often overlooked that workstations in a modern Windows environment are at the mercy of the user! If your application relies on an accurate date and time setting, you should consider including a line in the workstation’s logon script to synchronize the time with one of the servers. Many so-called bugs have been traced to a workstation that has had its date or time wrongly altered by the user. The following line of code, when added to the logon script of an NT/Windows 2000 machine, synchronizes the machine’s clock with that of a server called NTSERV1:
net time \\NTSERV1 /set
The date returned by
Nowtakes the Windows General Date format based on the locale settings of the local computer. The U.S. setting for General Date ismm/dd/yyhh:mm:ss.The
Nowfunction is often used to generate timestamps. However, for short-term timing and intra-day timestamps, theTimerfunction, which returns the number of milliseconds elapsed since midnight, affords greater accuracy.
See Also
| Timer Function |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access