Thanks everyone. Never really could find an easy was to do it in Flex, so I opted for the ease of ColdFusion to get it done quickly on the server side. Two easy CF functions, ParseDateTime and DateDiff.
Good news is Flash Builder adds some of the ease of ColdFusion, including CF tags, into Flex! Awesome stuff. Don Kerr --- In [email protected], Angelo Anolin <angelo_ano...@...> wrote: > > I think you would find it better to do the calculation on the database itself. > > All database have a lot of date/time diff functions which you can use. That > way, you all simply bind the data retrieved in your datagrid without the need > for calculating it. > > hth > > > > > ________________________________ > From: Don Kerr <fusionp...@...> > To: [email protected] > Sent: Monday, 29 June, 2009 8:51:22 > Subject: [flexcoders] Time Difference between two columns in DataGrid using > itemrenderer > > > > > > I have two columns in a datadrid, startTime (e.g. 04:30 PM) and endTime (e.g. > 06:00 PM). Both are strings and varchar in the database. > > I want to add a column to the datagrid that displays the difference between > these two times expressed in hours (e.g. 1.5 Hours). > > I'm trying to use an itemrenderer to do this calculation, but I've yet to be > successful. Having trouble converting the strings to date, then calculate > the hours. Can anyone help? > > Thanks, > Don >
