It seems to me that prodreccounttime is an integer and not a date/time object.
On Mon, Feb 7, 2011 at 12:21 PM, Orlini, Robert <[email protected]>wrote: > > 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:341949 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
