default value

[confused]

i have an unbound field with general date as format and
now() is the default value. is there a way to manipulate
the time portion of the now() so that i can put "default"
value of 11:59:59 AM on it? can i also define an input
mask for it?

thanks in advance.

 

[Newbie]

Try
=date() & " 11:59:59"

 

[John Spencer (MVP)]

One method

DateAdd("s",-1,DateAdd("d",1,Date()))