Generated an error: "__:__ is an invalid mask for the input number: 1630. The following table contains all valid NumberFormat masks:"
Still need to set field to date/time I figure. Thanks. RO HWW -----Original Message----- From: "Mark A. Kruger" <[email protected]> Sent: Monday, February 7, 2011 12:11pm To: "cf-talk" <[email protected]> Subject: RE: 2r hour time format Try this... Numberformat(prodreccounttime,"__:__") -Mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Orlini, Robert [mailto:[email protected]] Sent: Monday, February 07, 2011 10:33 AM To: cf-talk Subject: Re: 2r hour time format Thanks Ian and thanks all for your 2 cents! -----Original Message----- From: "Ian Skinner" <[email protected]> Sent: Monday, February 7, 2011 11:27am To: "cf-talk" <[email protected]> Subject: Re: 2r hour time format On 2/7/2011 8:24 AM, Orlini, Robert wrote: > Ahh. Good question. It is just numeric. I beleive I need to change it to date-time object? You will need to convert it, if you want to use the timeFormat() function. Otherwise you could just use some basic string manipulation functions to format the output in the desired way. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341948 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
