Create Start and End date column

[Marianjz]

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

[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.

Hope it helps!

Dan

[Jonathan-Sherman · Accepted solution]

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

[Marianjz]

Thank you!, works perfectly