Compare list with Date

Cannot compare List with Date in (MONTHLY REPORT REQUEST[Start Date] > [Latest WellStatus].[Date])

This is the Expression
IF( OR ( (monthly report request[start date])>[Latest WellStatus].[Date] , [last wellstatus before selected range].[well status] = “OFF”) , 0,
ANY(monthly report request[number of days]))
How do I fix this?
Any suggestion

MONTHLY REPORT REQUEST[Start Date] produces a list of all values from the Start Date column of the MONTHLY REPORT REQUEST table.

What are you trying to accomplish?

See also:

@Steve @Marc_Dillon
Through the expression, I am trying to set 2 IF conditions.
IF the date in list (MONTHLY REPORT REQUEST[Start Date] greater than [Latest WellStatus].[Date], and IF [last wellstatus before selected range].[well status] = “ON”, then the # of days (number value) is (monthly report request[number of days]–I have this value calculated in virtual column in Monthly report request table.
Then in the same expression, I want to satisfy another condition, (MONTHLY REPORT REQUEST[Start Date] greater than [Latest WellStatus].[Date], and IF [last wellstatus before selected range].[well status] = “OFF”, then # of Days=0

I get “Cannot compare List with Date” error

1 Like

Add in ANY()

4 Likes

Thanks @Marc_Dillon