Take latest update date data in workflow

[aaniqshaf]

Hello, I need help.

I want to take latest update data in my worflow. 

There I atteched with date data. 

 Example :

Brand	Process Start Time	Process End Time
Nike	2020-07-30 01:05:00	2020-07-30 01:07:00
Adidas	2020-08-31 02:05:00	2020-08-31 02:07:00
Adidas	2021-08-31 02:07:00	2021-08-31 02:09:00
Nike	2021-07-30 02:05:00	2021-07-30 02:07:00

Expected Output:

Brand	Process Start Time	Process End Time
Adidas	2021-08-31 02:07:00	2021-08-31 02:09:00
Nike	2021-07-30 02:05:00	2021-07-30 02:07:00

I want latest update data formula that created latest updated data and month.

[atcodedog05]

Hi @aaniqshaf 

Here is how you can do it. I was bit confused whether you wanted to only keep those records or map it back to data. Hence i have done both.

Workflow:

Hope this helps : )

[aaniqshaf]

Thanks!

[aaniqshaf]

Do you have formula on how to get latest update data in workflow?

Example:

There 2 date which 2021-06-01 and 2021-08-16.

So, i want to remove data 2021-06-01 and i want to latest data that currently updated now on that month. Let say this month is August, I want only August data with latest updated.

[atcodedog05]

Hi @aaniqshaf 

Here is how you can do it. To keep only current months data.

Workflow:

Hope this helps : )