Md JaHidur Rahman asked 10 years ago
i write like that. but its not working.
$grid["sortname"] = "STR_TO_DATE(date,'%d-%m-%Y')"; //IN DATABASE DATA LIKJE 10-03-20185
$grid["sortorder"] = "ASC"; // ASC or DESC
1 Answers
Abu Ghufran answered 10 years ago
Functions inside sortname is not supported. However, you can make another field in select_command e.g.
SELECT …. str_to_date(invdate,'%m-%d-%Y') as test ….
And use this 'test' field in sortname. As order by works in last by query processor, it should work.
Your Answer
