I’d like some assistance with writing an expression i feel dumb asking about.
Long story short, I got a “Vacation” table, for when people are on PTO vacation.
It has 2 columns,
“Start Date” ( the date the person begins vacation)
“End Date” ( the date the person ends vacation)
Simply put, I don’t want people to make a new entry if the Start Date is before an End Date already in the table. (They shouldn’t make a new vacation record if it’s within the time span of a previous one)
So I need a ValidIf formula that says “this row’s Start Date is greater than all this table’s End Dates”
I wrote the following formula,
[_THISROW].[Start Date] > [End Date]
but it always returns false, even when the new Start Date is greater than all End Dates.
I can’t figure out the problem solution. Does anyone have any insight?