Filter date base on two date comparision

(0) Share

Report

Posted on by daydinho10

124

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

daydinho10 124 on at

Like (0)

Report
Re: Filter date base on two date comparision

OK, I am able to solve this problem by using add column inside filter so there is additional column that I can use to filter.
Filter( AddColumns( 'Submission List', "IsLate", If( 'Submission Date' > 'Due Date', true, false ) ), IsLate = true )

Was this reply helpful? Yes No