View Full Version : What Time Is It ??!


popen
11-02-2000, 06:56 AM
OK, this is about time.
I have a field on a form that shows the current time [=Now()], and another that will show the current time plus 30 minutes.
I need help in how to set the default on this field to be 30 minutes from the time in the current field.
This is really easy, I know, but I have forgotten how to do this.
Can you help ?
Thank you

simongallop
11-02-2000, 07:56 AM
=now() + 30/24/60 will give you the half hour. (+30 is days so need to divide by hours then minutes) Change now() to control name.

HTH

Simon

popen
11-02-2000, 08:18 AM
Thanks for that...

-Neil Pope

R. Hicks
11-02-2000, 06:21 PM
Why not just:

=DateAdd("n",30,[YourFieldName])
Or
=DateAdd("n",30,Now())


HTH
RDH