Re: Date format in HTML cfgrid

2011-02-05 Thread Pete Ruckelshaus
Well, it won't support properly in your SQL solution because you've converted it to a varchar. Pete On Thu, Feb 3, 2011 at 10:13 AM, Steve Sequenzia wrote: > > I am trying to format dates in an HTML cfgrid. I cannot seem to make it > work in CF when using HTML as the grid type. I have also tri

Date format in HTML cfgrid

2011-02-03 Thread Steve Sequenzia
I am trying to format dates in an HTML cfgrid. I cannot seem to make it work in CF when using HTML as the grid type. I have also tried doing it in MSSQL by using - CONVERT(VARCHAR(10), startDate, 101) AS startDate. When I do that it shows up right in the grid but the grid will not sort on the