I would say it is not a valid date format...even at the most, a date would have 8 digits...12312006. If that is also including the time, then I think you have to parse out the individual components to display it. If the date is really 12/7/93...you are going to have issues in doing a generic parsing without a lot of code to take into account variation in format, like not using leading 0's to maintain spacing (120793). What does the number represent?
Eric -----Original Message----- From: Johnny Le [mailto:[EMAIL PROTECTED] Sent: Friday, 02 June 2006 19:56 To: CF-Talk Subject: Re: How to convert a number into date? How? I tried dateFormat(number, "mm/dd/yy") and it returns 12/02/292269055. I think it is because it is supposed to return both date and time. Let me know if you want to format it to display both date and time. Johnny >Did you try dateFormat()? > >-----Original Message----- >From: Johnny Le [mailto:[EMAIL PROTECTED] >Sent: Friday, June 02, 2006 7:00 PM >To: CF-Talk >Subject: How to convert a number into date? > >Hi, > >How do I turn this number 127937470871482500 into date? When I tried >isNumericDate(), it returns yes, but I don't know how to display it in >a readable format. >Thanks. > >Johnny ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242190 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
