Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
maybe like this:
date(Rangemax(DATE_1,DATE_2,DATE_3,DATE_4))
very good!
thank you @Frank_Hartmann