I have noticed that the dates in my inbox are not sorting properly. Even when I provide the instance_name in the format of 'year / month / day' ('%Y %b, %d'), it does not seem to honor it. I have also tried using the filter options within the app, but it still does not sort the assignments accurately. My goal is to sort the assignments by year, then month, and then date from furthest to latest. Any assistance would be appreciated.
| if(${nextinspection} - today() <= 0, concat('<font color="red"><b>', format-date(${nextinspection}, '%Y %b, %d'), '</b>, ', "Past Due","<br>", ${nextinspection}, '</font>'), concat('<font color="orange"><b>', format-date(${nextinspection}, '%Y %b, %d'), '</b>, ', "Coming Soon","<br>", ${nextinspection}, '</font>')) |
|
