How to Add 4 Hours to my Default Value?

[cw via AccessMonster.com]

I have an UnBound Text field on my Form:

The Format value is set to = mm-dd-yyyy hh:nn am/pm (ex: 07-25-2006 03:00 PM)
The Default value is set to = Now()

Question:

How do I make the Default Value display as: 07-25-2006 07:00 PM
(The default value should always be 4 hours later?)

I tried

=Now() + 04:00

but get Invalid Syntax

Thanks
cw

 

[Guest]

Hi.

Try this:
=DateAdd("h",4,Now())

-Michael

 

[Guest]

Hi CW,

Use the DateAdd function:

=DateAdd("h",4,Now())

http://msdn.microsoft.com/library/d...-us/vbenlr98/html/vafctDateAdd.asp?frame=true


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________