Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys. So I have a table that has several (about 10) date fields. In the script, I want to create a derived field that is the earliest of those several date fields. I can't use the min function, which aggregates among rows. I want to look at a single row, and compare field A, B, C, ... and pick out the lowest value. Any ideas? Thanks!
Eric
Use RangeMin and then apply function date() on top of it:
Date(RangeMin(Date1, Date2, Date3, ...))