Difference between now, date, and time

  • Thread starter Thread starter David
  • Start date Start date
D

David

Hi All,

What is the difference between Now() and Date() or Time(). I tried using
the Time() function and it worked on my home computer but not at work
I had to change it to Now().

TIA,
David
 
David said:
Hi All,

What is the difference between Now() and Date() or Time(). I tried using the
Time() function and it worked on my home computer but not at work I had to
change it to Now().
Click to expand...

Date() returns current system date with a time of midnight

Time() returns current system time with Date of 12/30/1899

Now() returns current system date and time.

Failure of any of these is a classic symptom of having missing or broken VBA
references. Open a code window then...

Tools - References

....and look at all of the checked items. If any have the word "MISSING" after
them that is your problem. Those need to be either removed or corrected.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table macro filter data between yesterday and today (date+time) 0
Date search query 0
Calculation difference 2 dates - #Name? error 2
Time difference and If function 4
Text to date format? 0
Date() not functioning as expected 12
What is the difference between the functions DATE() and NOW()? 6
Time between 2 dates 3

Back
Top