How to get minimum value across multiple fields in a single row?

[#1]

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

[Oleg_Troyansky]

Use RangeMin and then apply function date() on top of it:

Date(RangeMin(Date1, Date2, Date3, ...))