Agreed, Don, and Marco. However, ODBC date/times aren't that hard to work
with once you get used to their usage. Manipulating the date/time as
anything but a date/time is a pain... Both Access and CF have good date/time
features built in. And once you use them enough they become second nature.
In Access, use the date/time date type for the field. From your code just
INSERT or UPDATE using either #CreateODBCDate(some_date [Now()])#, or
#CreateODBCDateTime(some_date [Now()])#. Alternatively, look into
#CreateTimeSpan()# to format mask your own time spans, etc.
Oh yeah, and RTFM on both products--online Help is also good in both
products... ;). I'm not meaning to be facetious by saying that either. It's
just that you'll never learn this stuff until you read and understand it in
your own way, practice it according to your personal needs, and let it
become second nature to the way you code.
Good luck!
Cheers,
--
David L. Rice
Web Development Consultant
[EMAIL PROTECTED]
Q: 177820
24/7 cell: 770.354.5953
----------------------------
> -----Original Message-----
> From: Don Vawter [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, April 29, 2000 10:25 AM
> To: [EMAIL PROTECTED]
> Subject: Re: RE: Unable To insert Proper Date
>
>
> IMO this is bad advice. What if you want to sort by date?
> Better to learn
> the correct format rather than take the easy way out.
>
> ----- Original Message -----
> From: "Shane Witbeck" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, April 29, 2000 7:58 AM
> Subject: RE: RE: Unable To insert Proper Date
>
>
> > Keep your access datatype as text.
> >
> > Sincerely,
> >
> > Shane Witbeck
> > Webmaster
> > [EMAIL PROTECTED]
> > www.digitalsanctum.com
> >
> >
> >
> >
> > -----Original Message-----
> > From: Shally Kon [mailto:[EMAIL PROTECTED]]
> > Sent: Saturday, April 29, 2000 1:35 AM
> > To: [EMAIL PROTECTED]
> > Subject: RE: RE: Unable To insert Proper Date
> >
> >
> > Thanks a lot at last I am able to popup the current date.
> > But one more question can u please tell me which datatype
> should I specify
> > for my date field. I have specified it as"date/time" as I
> am using access
> > datatype but the value being inserted is
> > "12:00:06 AM" and not the currentdate.
> > Please suggest.
> > ------Original Message------
> > From: "Marco Gil" <[EMAIL PROTECTED]>
> > To: [EMAIL PROTECTED]
> > Sent: April 29, 2000 4:54:00 AM GMT
> > Subject: RE: Unable To insert Proper Date
> >
> >
> > Hey Shally,
> >
> > What I've done is the following... instead of using:
> >
> > #CreateODBCDate(Now()#
> >
> > I use :
> >
> > #DateFormat(now(), "MM/DD/YYYY")#
> >
> > That has worked flawlessly for me... put that in your VALUE
> parameter...
> Let
> > me know if it works out okay for ya.
> >
> > Marco
> >
> > ----- Original Message -----
> > From: "Shally Kon" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Saturday, April 29, 2000 12:53 AM
> >
> >
> > > Please help me!
> > > I am trying to insert 3 fields plus current date into my
> table .What I
> > want
> > > is that when ever the form is loaded the current date should popup
> > > automatically in the format "mm/dd/yyyy" and when I press
> submit button
> > then
> > > all the fields plus the current date should be inserted
> in the table.I
> am
> > > using Create date function.but the output I am getting is "{d
> > '2000-04-28'}"
> > > as the output.I am using access database and have
> specified the datatype
> > of
> > > date field as "date/time".
> > > <cfinput type="text" name="Date" size="10" maxlength="10"
> required="yes"
> > > validate="Date" message="Date is required!"
> > value="#CreateODBCDate(Now())#">
> > >
> > > -----------------------------------------------
> > > FREE! The World's Best Email Address @email.com
> > > Reserve your name now at http://www.email.com
> > >
> > >
> >
> >
> --------------------------------------------------------------
> ------------
> > ----
> > > Archives: http://www.eGroups.com/list/cf-talk
> > > To Unsubscribe visit
> >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/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.
>
> -----------------------------------------------
> FREE! The World's Best Email Address @email.com
> Reserve your name now at http://www.email.com
>
>
> --------------------------------------------------------------------------
--
> --
> 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.
----------------------------------------------------------------------------
--
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.
