Chk date column C in column D

[fairymemay (noona)]

I want to loop check column C that have date today or not.
If have data today read column B and column D.
else don’t have exit.

Please guide me for solve it.

Calendar_DueDate_DirectDebit.xlsx (14.7 KB)

[Yoichi]

Hi,

How about either of the following?

Use ForEachExcelRow (Main.xaml)

Use LINQ (Sequence.xaml)

Sample
Sample20231106-1L.zip (17.3 KB)

Note: This sample returns first matched data. If you need to return all matched data, it’s necessary to remove Break activity in the first sample.

Regards,

[fairymemay (noona)]

I have question.
In message box = output column B and D format date wrong.
correct = dd/mm/yyyy = 04/11/2023 (date on only don’t want time)

Please guide me for solve it.

[Yoichi]

Hi,

Can you try the following expression?

CDate(CurrentRow("ExtractDate").ToString).ToString("dd/MM/yyyy")+vbcrlf+CDate(CurrentRow("DueDate_DirectDebit").ToString).ToString("dd/MM/yyyy")

Regards,