Difference between date and now()

[marcin2k]

Anyone know the difference between date and now(). I noticed that using Now() after noon gives a different date then using is before noon. Why is this? Thanks any help would be great.

 

[PHV]

Date() returns a date and Now() returns a timestamp.
e.g:[tt]
Date: yyyy-mm-dd 00:00:00
Now: yyyy-mm-dd hh:nn:ss[/tt]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ZmrAbdulla]

Date() is only date
Time Only time
Now() is date with time

Try those on immediate window result will be
?date
08/09/2005
?Time
4:52:17 PM
?Now
08/09/2005 4:52:23 PM

________________________________________________________
Zameer Abdulla
Help to find Missing people
You may be the boss' pet; but you are still an animal

 

[abaldwin]

If now gives a different date after noon then you need to check your AM PM Settings on your clock.



Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[PHV]

Check your Time Zone (double click the system clock in the systray)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886