Using the Tiller Money Feeds extension in Google Sheets, the AutoCat tool lets you create rules with the Advanced Rule Builder. One of the options is to create a rule for the Date column using Equals, Max, or Min criteria. The rule builder creates this column in the AutoCat sheet if it doesn’t already exist. The column that’s created is formatted as plain text and as a result the comparisons for Max and Min do not work correctly.
I suggest that the Tiller team should take a look and consider updating the Advanced Rule Builder to check the format of the column referenced by the filter criteria and reuse that same formatting for the new column it creates in the AutoCat sheet.
Users can workaround this by reformatting the created column themselves.