What Time Is It ??! (1 Viewer)

popen

Registered User.
Local time
Today, 23:18
Joined
Oct 16, 2000
Messages
37
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

Registered User.
Local time
Today, 23:18
Joined
Oct 17, 2000
Messages
611
=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

Registered User.
Local time
Today, 23:18
Joined
Oct 16, 2000
Messages
37
Thanks for that...

-Neil Pope
 

R. Hicks

AWF VIP
Local time
Today, 18:18
Joined
Dec 23, 1999
Messages
619
Why not just:

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


HTH
RDH
 

Users who are viewing this thread

Top Bottom