Default value

  • Thread starter Thread starter JFB
  • Start date Start date
J

JFB

Hi,

I would like to place a default value in a date/time field. Here is the format of the value:

16-12-2003 06:59:00 where the date is "date() + 1" and th time is always fixed to 06:59:00.

Is someone can tell me how to figure it?

Thanks!

JF
 
"JFB" <none> wrote in message
Hi,

I would like to place a default value in a date/time field. Here is the
format of the value:

16-12-2003 06:59:00 where the date is "date() + 1" and th time is always
fixed to 06:59:00.

Is someone can tell me how to figure it?

A solution only guaranteed in Access/Jet due to how it stores DateTimes
internally...

Date() + 1.290972222222222
 
Back
Top