Consolidation of the data based on the date

Help Automation Ops
,
1

After downloading the file from sap, there is the dates in a column, if any of the date is previous month date then it should merge in previous month file or it should merge in current month file, how to write the if.

2

Hi @anjani_priya

Can you try this In If activity

dt1.AsEnumerable().
Where(Function(r) DateTime.ParseExact(r("DateColumn").ToString, "dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture).Month = Now.AddMonths(-1).Month).
CopyToDataTable().RowCount>0

Note: Based on DateColumn format you need to change

Regards,

2 Likes
Forum Engagement Daily Reports
3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.