Angel, try this.

#TimeFormat('#DatePart('n',#eventtime#)#', 'mm')#

DatePart for minute 'n' is showing you the minute value for a specific time
(in your cast, 5, not 05 like you want). If you wrap that into TimeFormat,
specifying 'mm' (or minutes with leading zeros), that will solve your
problem.

Good luck.
Nick Call
[EMAIL PROTECTED]
www.nexsysdigital.com

----- Original Message -----
From: "Angel Stewart" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 26, 2002 3:12 PM
Subject: DatePart('n',#eventtime#) producing strange results


> Hey all,
>
> My simple statement within an input text box produces very odd results
> when The value is less than 10.
>
> I get 5 instead of 05
>  9 instead of 09....etc.
>
> If I enter
> 10 in the hours text box, and 05 in the minutes text box.
>
> It puts 10:05 as the time into the database, but it displays 5 when I
> use DatePart('n',#eventtime#) when it SHOULD display 05.
>
> Any ideas why??
>
> -Gel
>
>
>
>
>
>
> 
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to