jQuery Grid Plugin - jqGrid - Topic: Date sorting from MS SQL http://www.trirand.com/blog/?page_id=393/help/date-sorting-from-ms-sql Simple:Press Version 5.7.5.3 tony on Date sorting from MS SQL http://www.trirand.com/blog/?page_id=393/help/date-sorting-from-ms-sql#p7137 Help http://www.trirand.com/blog/?page_id=393/help/date-sorting-from-ms-sql#p7137 Hello,

If it is possible could you please send me a link to the problem.

My e-mail is tony at trirand dot com.

Thanks

Best Regards

]]> Tue, 09 Jun 2009 09:00:58 +0300 mweezer on Date sorting from MS SQL http://www.trirand.com/blog/?page_id=393/help/date-sorting-from-ms-sql#p7106 Help http://www.trirand.com/blog/?page_id=393/help/date-sorting-from-ms-sql#p7106 Tony,

That causes the grid to not display at all.  Any other ideas? 

Thanks - Mike

]]> Mon, 08 Jun 2009 20:12:41 +0300 tony on Date sorting from MS SQL http://www.trirand.com/blog/?page_id=393/help/date-sorting-from-ms-sql#p7073 Help http://www.trirand.com/blog/?page_id=393/help/date-sorting-from-ms-sql#p7073 Hello,

Try with datefmt:mm/dd/yy

Regards

Tony

]]> Fri, 05 Jun 2009 01:56:11 +0300 mweezer on Date sorting from MS SQL http://www.trirand.com/blog/?page_id=393/help/date-sorting-from-ms-sql#p7065 Help http://www.trirand.com/blog/?page_id=393/help/date-sorting-from-ms-sql#p7065 Hi Tony,

I don't think I stated the issue correctly.  I need it to sort by chronological order.  Right now it is displaying like this:

1/15/09

2/15/08

3/15/09

It isn't putting the dates in the correct order.

Thanks,

Mike

]]> Thu, 04 Jun 2009 10:40:36 +0300 tony on Date sorting from MS SQL http://www.trirand.com/blog/?page_id=393/help/date-sorting-from-ms-sql#p7053 Help http://www.trirand.com/blog/?page_id=393/help/date-sorting-from-ms-sql#p7053 Hello,

The date string from grid is allways converted to javascript date object, so you never get a chance to sort first by month then by day and the by year (if I understand right).

Try with sorttype:'text'

Regards

Tony

]]> Thu, 04 Jun 2009 05:00:32 +0300 mweezer on Date sorting from MS SQL http://www.trirand.com/blog/?page_id=393/help/date-sorting-from-ms-sql#p7018 Help http://www.trirand.com/blog/?page_id=393/help/date-sorting-from-ms-sql#p7018 Hi,

I'm trying to get jQuery Grid to sort by date, but it doesn't seem to work.

This line:

{name:'RecDate',index:'RecDate',width:350,sorttype:"date",datefmt:'mm/dd/yyyy'}

sorts by month, then by day, then by year.  The date is displayed from MS SQL by:  CONVERT(VARCHAR(12), d.RecDate, 101) AS RecDate,

This gives it the format of 'MM/DD/YY'

How do I get it sort the dates from oldest to newest?

Thanks - Mike

]]> Tue, 02 Jun 2009 17:04:22 +0300