yes, except you'll be using CF's dateadd function and not
access' so it would look like:
#dateadd("d",'form.days',Now())# (disclaimer:off the top of
my head)
Fred.
----- Original Message -----
From: "WL" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 07, 2000 3:39 PM
Subject: Re: Changing default date in Access Database
> "...if you do not specify a value." Of course - so I
could just as easily
> enter in DateAdd("d",'#form.days#',Now()) or something to
specify no of
> days, yes?
>
> Will
>
>
> Lukrative Media Ltd - Berkshire, UK
> ----- Original Message -----
> From: "Fred T. Sanders" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, May 07, 2000 9:36 PM
> Subject: Re: Changing default date in Access Database
>
>
> > A default is exactly that. It's just what will be
inserted
> > if you do not specify a value.
> >
> > Fred
> >
> > ----- Original Message -----
> > From: "WL" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Sunday, May 07, 2000 3:28 PM
> > Subject: Re: Changing default date in Access Database
> >
> >
> > > 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=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=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=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=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.
