Cristian Szabo asked 9 years ago
I try to use "cellcss" to format a 'date' cell.
The problem is with operator , apparently only '=' OR 'eq' works right. When try to use '<' OR 'lt', it produce unexpected results.
Any suggestion?
Thanks
1 Answers
Abu Ghufran answered 9 years ago
The problem is, it use JS comparison code and date format is not plain numeric.
To resolve this case, recommended way is to make a new column for formatting with
date_format(invdate,'%Y%m%d') as invdate_calc
Refer: https://phpgrid.desk.com/customer/portal/questions/8007309-date-cell-conditional-format
Your Answer
