Dates

[James_Yakupt (James)]

Hi Everyone

I have a scenario

In “Column 1” i have 2 dates are the same due to updating latest information. however, the “indicator” only sends once due to the same date.

Another case is that there is no addition update, so we only send it once.

May I know how detect the 2 dates into one date that has send?

[singh_sumit (Sumit Singh Tariyal)]

Hie @James_Yakupt after use read range and save the dt as dt1 . use for each row and inside the for each use one if condition and pass if currentrow(“indicator”).tostring = “never send” . then the statement goes to true …
cheers happy automation

[vrdabberu (Varunraj Dabberu)]

Hi @James_Yakupt

What is your exact condition and expected output. Please specify.

Regards

[James_Yakupt (James)]

The output must be the latest date and indicator

[James_Yakupt (James)]

Hi @singh_sumit

I would appreciate it if you could provide me step by step.

Thank you.