yes you said that already in a previous post. He'll use
your way if he needs exactly 30 days from the time its
entered he'll use my way if he really meant that he needs
the date to be exactly one month away from the date entered.
Both answers are right in their own way. Chill
----- Original Message -----
From: "Howie Hamlin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 07, 2000 3:13 PM
Subject: Re: Changing default date in Access Database
> 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=li
sts/cf_talk or send a message to
[EMAIL PROTECTED] with 'unsubscribe' in the
body.
------------------------------------------------------------------------------
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.
