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 <c...@thinksys.com> 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 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 date properly. > > Anyone know of a way to make it show up in the grid in a mm/dd/yyyy format > and also sort on the date properly? > > Any help would be great. > > Thanks in advance. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:341886 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm