Default TIME

  • Thread starter Thread starter Lee T.
  • Start date Start date
L

Lee T.

I would like a control's default to be N0W() - 10
minutes. I have tried going through the expresion builder
but cannot get it to work. Any ideas?

=now()-dateadd("nn",10,now()) just gives me an error
A2K3 in A2K format.

tia

Lee T.
 
I would like a control's default to be N0W() - 10
minutes. I have tried going through the expresion builder
but cannot get it to work. Any ideas?

=now()-dateadd("nn",10,now()) just gives me an error
A2K3 in A2K format.

tia

Lee T.
Click to expand...

=DateAdd("n",-10,Now())
 
Cheryl and Fred,

Thank you. I had also tried =dateadd("nn",-10,now())
but it had failed. The old Homer Simpson in me didn't
even think of just "n". I bet I wasted a half hour on
that at home last night.

Thanks again.

Lee T.
 
Hi,
Drop an unbound control field on your form
double click on the field to open the properties
At "Control Source" type: =Now()
click on the next field to save entry
Select "Format" of date field from drop down
Close
 
Back
Top