Have you considered doing the time formatting on the database rather than in CF? What DB are you using? This might be the easiest solution. In SQL Server try
SELECT CONVERT(varchar(2), DATEPART(hh, report_time)) + ':' + CONVERT(varchar(2), DATEPART (n, report_time)) AS thetime This should return the hour and minutes in 24 hour format... This is probably not the most optimal SQL statement... But it will return the properly formatted text. Also note that it's returned as a varchar and not a date/time... Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -----Original Message----- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 10:45 AM To: CF-Talk Subject: Re: value list of a timeformat Recieve a JIT error this way. Invalid parser construct found on line 18 at position 43. ColdFusion was looking at the following text: ( Invalid expression format. The usual cause is an error in the expression structure. <cfset report = valuelist(timeon.acd_total(timeformat(report_time, 'HH:MM')),',')> On Mon, 04 March 2002, "Douglas Brown" wrote: > > Looks like your missing a closing ) > > > > > > "Success is a journey, not a destination!!" > > > > Doug Brown > ----- Original Message ----- > From: "Joshua Tipton" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, March 04, 2002 9:07 AM > Subject: value list of a timeformat > > > > What is wrong with this? > > > > > > <cfset report = #valuelist(timeon.acd_total(timeformat(report_time, > "HH:MM"),',')#> > > > > > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
