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:242189 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