Sort by Date

Issue #18 resolved
Thomas Gerlach created an issue

Sort records by date, not entry order

Comments (2)

  1. Thomas Gerlach reporter

    Date field is not formatted correctly to sort as a date. Changed the order by clause to resolve the issue.

    datetime(substr(date,7,4) || '-' || substr(date, 4, 2) || '-' || substr(date, 1, 2) || ' ' || time) desc
    
  2. Log in to comment