Forum Discussion
Solved
Find earliest date across multiple columns
Any ideas for code to return the earliest date across multiple columns? My table has at least five date columns, I need to return the earliest date per row.
Hi mclarin , I am assuming this is a calculated column. Let me know if this works, as I did it free hand.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielCalculated column = VAR _earlycol1 = table[col1] VAR _earlycol2 = table[col2] VAR _earlycol3 = table[col3] VAR _earlycol4 = table[col4] VAR _calc1 = IF ( _earlycol1 < _earlycol2, _earlycol1, _earlycol2 ) VAR _calc2 = IF ( calc1 < _earlycol3, _calc1, earlycol3 ) VAR _calc3 = IF ( _calc2 < _earlycol4, _calc2, _earlycol4 ) RETURN _calc3
Thank you Nathaniel_C . This worked great. Since most of the columns were blank, I also performed a check for that, but otherwise, this solved it.
Nathaniel_C
Community Champion
Community Championmclarin ,
You are welcome! Glad it worked!
Nathaniel
