Hello folks.
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?
Solved! Go to Solution.
Your expression:
[_THISROW].[Start Date] > [End Date]
Compares the Start Date column value of the row with the End Date column value of the same row.
Given this:
It seems like you want:
([Start Date] > MAX(Vacation[End Date]))
See also:
Your expression:
[_THISROW].[Start Date] > [End Date]
Compares the Start Date column value of the row with the End Date column value of the same row.
Given this:
It seems like you want:
([Start Date] > MAX(Vacation[End Date]))
See also:
Yes! that was i was looking for. Agh, I knew it was a dumb question. Many thanks for the swift response, Steve!
User | Count |
---|---|
40 | |
36 | |
33 | |
23 | |
17 |