I though this would be simple but it turn out very strange. I have sharepoint list (Submission List) with two date columns, 'Due date' and 'Submission Date'. I am using gallery to show the list and now I want to filter the list in the gallery that 'Submission Date is greater than 'Due Date'. My code as below. It works if I compare it with today's date but when compare the two date, it return blank. I do have the list with 'Submission Date' less than 'Due Date'. The column is Date Time column with include time turn off
Filter('Submission List', 'Submisssion Date' > 'Due Date')
I do want delegation to work if that possible.