Compare list with Date

ABBA
Participant V

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

Solved Solved
0 4 1,949
1 ACCEPTED SOLUTION

Add in ANY()

View solution in original post

4 REPLIES 4

Steve
Participant V

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:

ABBA
Participant V

@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

Add in ANY()

Thanks @Marc_Dillon

Top Labels in this Space