Default value

[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

 

[Rick Brandt]

"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

 

[JFB]

Thanks! It work great!

JF