Cool thanks guys. One other question - if I need to dynamically change the
entry of this for one instance, can I do this? So is it possible for me to
override the default 30 days and change it to 15,60 or 90 - or can't the
default be over-ridden?
Thanks,
Will
Lukrative Media Ltd - Berkshire, UK
----- Original Message -----
From: "Fred T. Sanders" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
Sent: Sunday, May 07, 2000 9:25 PM
Subject: Re: Changing default date in Access Database
> 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.
------------------------------------------------------------------------------
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.
