Find the minimum date in columns

[LawrenceMa]

Hello, 

I have 3 columns - [Date 1], [Date 2] & [Date 3].

I also would like to create a Virtual Column [Min Date] as below:

Date 1	Date 2	Date 3	Min Date
20/5/2020	21/5/2020	22/5/2020	20/5/2020
25/5/2020	24/5/2020	23/5/2020	23/5/2020
25/5/2020	24/5/2020	26/5/2020	24/5/2020

I wrote in app formula to Virtual column: min([Date 1], [Date 2], [Date 3])

However It returns error: MIN function is used incorrectly

How can I rewrite the formula to get the minimun date from those 3 Date columns? Thank you.

@Steve @Joseph_Seddik @Marc_Dillon @Suvrutt_Gurjar @Rafael_ANEIC-PY 

[Koichi_Tsuji · Accepted solution]

Try this.

min(List([Date 1], [Date 2], [Date 3]))

[Koichi_Tsuji · Accepted solution]

Try this.

min(List([Date 1], [Date 2], [Date 3]))

[Rafael_ANEIC-PY · Accepted solution]

Hello @LawrenceMa, try this

MIN(LIST([Date 1], [Date 2], [Date 3]))