sorry that i did not told you this, as i'm using a Sybase database, i
retrieve the date data from the database and pass into the cfa_datepicker as
the defaultDate, i use your method and that's no error but when i replace
the DATESTR with the data i got from Sybase i get this error message :
Error Diagnostic Information
ERROR: you must use valid format for default euro dates (dd/mm/yyyy)
i do an output on the data from sybase it show this : Jan 29 2001 12:00AM
i found on that if the date is in this format : {ts '2001-01-29 00:00:00'}
or "05/03/2001" then the cfa_datepicker works fine. is tehre anyway to
convert Jan 29 2001 12:00AM to another format that may work with
cfa_datepicker?
----- Original Message -----
From: Raymond Camden <[EMAIL PROTECTED]>
To: Spectra-Talk <[EMAIL PROTECTED]>
Sent: Monday, February 05, 2001 9:24 PM
Subject: RE: cfa_datepicker
> Change dateformat str to mm/dd/yyyy. The drop down will still be in
> Euro-format, ie, with the day of the month first. You said you got an
error
> with it, but I did not. Try this code and let me know if it doesn't work
for
> you:
>
> <CFSET MYDATESTR = "05/03/2001">
> <CFSET MYDATE = ParseDateTime(MYDATESTR)>
> <cfa_datepicker
> name="form1"
> defaultDate="#dateformat(myDate,"mm/dd/yyyy")#"
> bSubmitMonthNames="No"
> bDisplayMonthNames="Yes"
> startyear="2000"
> endyear="2020"
> bUseEuroDates="yes">
>
> =======================================================================
> Raymond Camden, Principal Spectra Compliance Engineer for Allaire
>
> Email : [EMAIL PROTECTED]
> ICQ UIN : 3679482
>
> "My ally is the Force, and a powerful ally it is." - Yoda
>
> > -----Original Message-----
> > From: Mak Wing Lok [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, February 05, 2001 3:30 AM
> > To: Spectra-Talk
> > Subject: cfa_datepicker
> >
> >
> > help needed
> >
> > when i use the cfa_datepicker in euro dates format the whole
> > thing mess up.
> >
> > i have a date in US date format and when i pass it into cfa_datepicker,
it
> > show me the wrong date, eg: the date is 05/03/2001 (US Date), it
> > show me 05
> > March 2001 when it should show 03 May 2001
> > here's my code :
> >
> > <cfa_datepicker
> > name="form1"
> > defaultDate="#dateformat(myDate,"dd/mm/yyyy")#"
> > bSubmitMonthNames="No"
> > bDisplayMonthNames="Yes"
> > startyear="2000"
> > endyear="2020"
> > bUseEuroDates="yes">
> >
> > i can't changed the defaultDate into dateformat(myDate,"mm/dd/yyyy") as
it
> > give me an error saying if with bUseEuroDates set op "yes" the date
format
> > should be dd/mm/yyyy
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
