Thank you all. I looked over the livedocs for CF and formatted it this way:
#TimeFormat(get.prodreccounttime, "hh:mm:ss")# However, instaed of the time "1630" becoming "16:30" I get "12:00:00". What did I do wrong here? RO -----Original Message----- From: "Robert Harrison" <[email protected]> Sent: Monday, February 7, 2011 10:25am To: "cf-talk" <[email protected]> Subject: RE: 2r hour time format CreateTime, TimeFormat() ... see CF documentation. Robert B. Harrison Director of Interactive Services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be &. Plug in to our blog: A&W Unplugged http://www.austin-williams.com/unplugged -----Original Message----- From: Orlini, Robert [mailto:[email protected]] Sent: Monday, February 07, 2011 10:17 AM To: cf-talk Subject: 2r hour time format Hello, Is there a way to format 24 hour time? Right now it dispalys as "1630 count time" for example. I would like it to read "16:30". Could not find an example wit he Format filter. Thanks. RO HWW ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:341936 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

