Compare list with Date

[ABBA]

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

[Steve]

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:

help.appsheet.com

List Expressions and Aggregates

List expressions use and/or produce lists of values.

[ABBA]

@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

[Marc_Dillon · Accepted solution]

ABBA:

IF( OR ( ( ANY( monthly report request[start date] ) )>[Latest WellStatus].[Date] , [last wellstatus before selected range].[well status] = “OFF”) , 0,
ANY(monthly report request[number of days]))

Add in ANY()

[ABBA]

Thanks @Marc_Dillon