Filtering DocLister Items by a TV Date Field

Date filtering looks simple until the same TV stores values in two slightly different formats, such as 11-05-2019 and 11-05-2019 0:00:00. Once that happens, direct comparisons become unreliable unless the format is normalized first.

The real issue

DocLister can filter and sort by TV data, but mixed date formats make comparisons fragile. Before you ask for “all documents with a date after today,” make sure the stored values follow one predictable format.

Best practice

• normalize the TV value before comparison
• prefer a machine-friendly date format for new data
• convert legacy values before relying on range filters

Why normalization matters

If one item stores only a date and another stores a date-time string, the output may still look correct to editors, but query logic has to guess how to compare them. That is where “simple” date filters start failing.

The cleaner the date format, the easier every later step becomes: sorting, filtering, expired items, upcoming events, and archive generation.