Sure, first use ParseDateTime. This will (should) turn your string into a
real date object. That should do it, actually. Give it a try.
=======================================================================
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 7:36 PM
> To: Spectra-Talk
> Subject: Re: cfa_datepicker
>
>
> 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?
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
