Date filter not working
I'm using Yellowfin 7.35.17. Datasource is a Filemaker 17 database.
I'm having trouble trying to apply a filter on a date column.
I've created a test report to play around with, which only contains one column. The SQL produced by the report is as follows:
SELECT DISTINCT "INVOICES"."CREATION DATE" FROM "INVOICES" WHERE ( "INVOICES"."CREATION DATE" <= '2023-04-01' )The results for this shows me all the records from today 1/05/2023 down to 14/12/2022. If I change the operator to '>', I get no results.
The dates appear in Filemaker in the format d/MMM/yyyy. This is also the format of the system clock on the Yellowfin server and on the client machine.
I am perplexed as to what is going on.