in hh:mm:ss u can use more masks.
regards
__
MSc. Hassan Arteaga Rodríguez
Microsoft Certified System Engineer.
DIGI- Grupo de Desarrollo
COPEXTEL, S.A.
-----Original Message-----
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 08:32 AM
To: CF-Talk
Subject: Create date problem
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]
