Guriddo » Topic: Date sorting from MS SQL

Date sorting from MS SQL

Guriddo
Date sorting from MS SQL

This topic has 5 replies, 2 voices, and was last updated 17 years, 1 month ago by tony.

Creator

Topic
June 2, 2009 at 5:04 pm #73448

mweezer
Participant

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.
Creator

Topic

Viewing 5 replies - 1 through 5 (of 5 total)

Author

Replies
June 4, 2009 at 5:00 am #87120

tony
Keymaster

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

June 4, 2009 at 10:40 am #87129

mweezer
Participant

Hi Tony,

I don't think I stated the issue correctly.

June 5, 2009 at 1:56 am #87136

tony
Keymaster

Hello,

Try with datefmt:mm/dd/yy

Regards

Tony

June 8, 2009 at 8:12 pm #87151

mweezer
Participant

Tony,

That causes the grid to not display at all.

June 9, 2009 at 9:00 am #87178

tony
Keymaster

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
Author

Replies

Viewing 5 replies - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

Copyright 2014 TriRand LtdAll Rights ReservedRSS