Create date problem

[Robert Orlini]

I'm trying to convert this date/time info from the filed #datetime#: 20031201 03:38 PM into something CF can display correctly.
I'm using CreateDate for "20031201". How do I also get the time "03:38 PM" separated?
In other words I would like to have the #DateFormat((Datetime), "mmm-dd-yyyy")# display both the date and time formatted.
--------------------------------------------
This is what I have so far, but of course it gives me an error because of the 03:38 PM.
<CFSET Datetime = (CreateDate(left(datetime, 4), Mid(datetime, 5, 2), Right(datetime, 2)))>
#DateFormat((Datetime), "mmm-dd-yyyy")#
--------------------------------------------------------

Thanks.

Robert O.

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---