min of two date columns

radhikaa4 — Wed, 03 Jun 2020 20:37:23 GMT

Hi I have the following dataset

What I would like to do is to capture min two date time values, if missing use whichever one is available

New dataset

The only way I can think of is transpose and combine into one date field and then use min. Was wondering if there is another easier way

Re: min of two date columns

Reeza — Wed, 03 Jun 2020 20:40:24 GMT

Isn't that just the MIN() function?

min_stop_date_time = MIN(first_stop_date_time, second_stop_date_time);