That will only work if the month has 30 days. Otherwise you would use
DateAdd("d",30,Now())
Howie
----- Original Message -----
From: Fred T. Sanders <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 07, 2000 4:04 PM
Subject: Re: Changing default date in Access Database
> In the default value on the database for your date/time
> field change from now() to
>
> DateAdd("m",1,Now())
>
> ----- Original Message -----
> From: "WL" <[EMAIL PROTECTED]>
> To: "Cold Fusion Talk" <[EMAIL PROTECTED]>
> Sent: Sunday, May 07, 2000 2:36 PM
> Subject: Changing default date in Access Database
>
>
> > Hi,
> >
> > I need to change the default for a date field - at the
> moment it
> > automatically enters todays' date, but I need it to enter
> 30 days ahead of
> > todays date. Can this be done in Access?
> >
> > Thanks,
> >
> > Will
> >
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
