Create Start and End date column

Hi everyone

I need to create 2 columns Start Date and End Date like the following:

ID TYPE CODE STATUS Start Date End Date

17568020 B ABCDE Completed 1/23/2020 22:36 1/23/2020 22:46

The row data is the following

ID TYPE CODE STATUS Start Date

17568020 B ABCDE Completed 1/23/2020 22:36
17568020 B ABCDE Completed 1/23/2020 22:37
17568020 B ABCDE Completed 1/23/2020 22:38
17568020 B ABCDE Completed 1/23/2020 22:39
17568020 B ABCDE Completed 1/23/2020 22:40
17568020 B ABCDE Completed 1/23/2020 22:41
17568020 B ABCDE Completed 1/23/2020 22:42
17568020 B ABCDE Completed 1/23/2020 22:43
17568020 B ABCDE Completed 1/23/2020 22:44
17568020 B ABCDE Completed 1/23/2020 22:45
17568020 B ABCDE Completed 1/23/2020 22:46

I need help!

Thanks in advance

Workflow

Developer

Accepted answers

Jonathan-Sherman

Hi @Marianjz,

I would approach it by summarising:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200130 - SummarisingStartEndDate.yxmd

All comments

danrh

Look into the Summarize Tool. Group by your other columns (ID, Type, Code, Status), then take the MIN of your date column for your start date and the MAX of that same date column for your end date.