Take latest update date data in workflow

Question

Hello, I need help.

I want to take latest update data in my worflow.

There I atteched with date data.

Example :

BrandProcess Start TimeProcess End TimeNike2020-07-30 01:05:002020-07-30 01:07:00Adidas2020-08-31 02:05:002020-08-31 02:07:00Adidas 2021-08-31 02:07:002021-08-31 02:09:00Nike2021-07-30 02:05:002021-07-30 02:07:00

Expected Output:

BrandProcess Start TimeProcess End Time      Adidas 2021-08-31 02:07:002021-08-31 02:09:00Nike2021-07-30 02:05:002021-07-30 02:07:00

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

atcodedog05 · Answer

Hi @aaniqshaf

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

Workflow:

Hope this helps : )

current month data.yxmd

aaniqshaf · Answer

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.

aaniqshaf · Answer

Thanks!