max date distinct fields

[tincholiver]

hello everyone,

how is possible to get de max date between fields? 

Example:

Data Table
ID	DATE_1	DATE_2	DATE_3	DATE_4	Desired data
1	30/4/2021	10/5/2021	5/7/2021	4/8/2021	4/8/2021
2	20/4/2021	13/5/2021	11/6/2021	23/6/2021	23/6/2021
3	14/8/2021	26/8/2021	17/5/2021	22/7/2021	26/8/2021
4	29/4/2021	11/7/2021	27/5/2021	10/6/2021	11/7/2021
5	12/2/2021	23/4/2021	12/2/2021	30/6/2021	30/6/2021

[Frank_Hartmann · Accepted solution]

maybe like this:

date(Rangemax(DATE_1,DATE_2,DATE_3,DATE_4))

[tincholiver]

very good! 

thank you @Frank_Hartmann