Min and Max date from 8 different columns

[Michiel_QV_Fan]

Hi,

How can I find the min date and the max date from my data?

I have 1 unique ID with 8 different date fields. Some fields are empty.

To fill my kalender right I need a single field with all unique possible dates from those 8 columns.

Thanks

[#2]

show this functiont ---> FIRSTSORTVALUE.

bYE

mARCO

[kumarnatarajan]

Hi,

Use "FIRSTSORTEDVALUE" function.

Min Date data:

Syntex = FirstSortedValue(fieldName,date)

Max Date data:

Syntex = FirstSortedValue(fieldName,-date)

[Michiel_QV_Fan]

This isn't working because I have to evaluate 8 different columns.

[Michiel_QV_Fan · Accepted solution]

RANGEMIN(DATE,DATE,DATE,DATE, ....) AS FIRSTDATE

RANGEMAX(DATE,DATE,DATE,DATE, .... ) AS LASTDATE