## returning the first event date

Solved
Frequent Contributor
Posts: 133

# returning the first event date

``````id event_beg_date event1_end  event2_end event3_end
1    01/01/2005  04/05/2005  03/10/2005  06/01/2005``````

I have the above code. I want to calculate the number of days between the event_beg_Date and the first event that happen across the three event dates.

So for example above, the code should retain the number of days between 01/01/2005 and 03/10/2005

Accepted Solutions
Solution
‎11-04-2016 06:28 PM
Super User
Posts: 21,985

## Re: returning the first event date

Dates are numeric so you can use the MIN() function to find the earliest date.

``duration = min(event1_end, event2_end, event3_end) - event_beg_date;``

All Replies
Solution
‎11-04-2016 06:28 PM
Super User
Posts: 21,985

## Re: returning the first event date

Dates are numeric so you can use the MIN() function to find the earliest date.

``duration = min(event1_end, event2_end, event3_end) - event_beg_date;``

☑ This topic is solved.