Sorting by a Date in a Text Field

2 posts by 2 authors in: Forums > CMS Builder
Last Post: December 24, 2012   (RSS)

By gkornbluth - December 24, 2012

Hi Sid,

I think that the best approach, assuming it can be done easily enough is to use date fields. They would offer the kind of flexibility that you need now and many other options down the road.

I'm not sure how many records you'd need to convert at this point, or where you get the original data from and what format it's in.

It's a bit over my head, but if it's a number crunching issue and conversion that's too big to handle manually, the gurus at IT might be able to work out an algorythm to handle the format conversions required.

Just my thoughts,

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php