Default TIME

[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.

 

[Cheryl Fischer]

How about ...

DateAdd("n", -10, Now())

 

[fredg]

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.

=DateAdd("n",-10,Now())

 

[Lee T.]

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.

 

[Guest]

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