I have a formulat to clacualte the Days Until but I am looking to use a similar formula for days before.
IE: this is will give the latest date entered in one of the date fields but Im looking for the earliest date also.
Can anybody please give me some pointers on how to acheive this?
Thank you
ifElse(
equal(daysUntil($measure_1_install_date_c),
min(daysUntil($measure_1_install_date_c),
daysUntil($measure_2_install_date_c),
daysUntil($measure_3_install_date_c),
daysUntil($measure_4_install_date_c),
daysUntil($measure_5_install_date_c))),
$measure_1_install_date_c,
ifElse(equal(daysUntil($measure_2_install_date_c),
min(daysUntil($measure_1_install_date_c),
daysUntil($measure_2_install_date_c),
daysUntil($measure_3_install_date_c),
daysUntil($measure_4_install_date_c),
daysUntil($measure_5_install_date_c))),
$measure_2_install_date_c,
ifElse(equal(daysUntil($measure_3_install_date_c),
min(daysUntil($measure_1_install_date_c),
daysUntil($measure_2_install_date_c),
daysUntil($measure_3_install_date_c),
daysUntil($measure_4_install_date_c),
daysUntil($measure_5_install_date_c))),
$measure_3_install_date_c,
ifElse(equal(daysUntil($measure_4_install_date_c),
min(daysUntil($measure_1_install_date_c),
daysUntil($measure_2_install_date_c),
daysUntil($measure_3_install_date_c),
daysUntil($measure_4_install_date_c),
daysUntil($measure_5_install_date_c))),
$measure_4_install_date_c,
ifElse(equal(daysUntil($measure_5_install_date_c),
min(daysUntil($measure_1_install_date_c),
daysUntil($measure_2_install_date_c),
daysUntil($measure_3_install_date_c),
daysUntil($measure_4_install_date_c),
daysUntil($measure_5_install_date_c))),
