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)
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)
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,
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.
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,
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.