Day conversion from date

hey all,
I want to get the day from the dates and here is the question=
. Check the report from D6 and look for only W1 only. If there is W1 for Monday add all the amounts from the weekend and W1 and key in on Possible Duplicate Message

how to solve this?
this is the data

Create a for each row and inside try this in If activity
Convert.ToDateTime(row(1).tostring).DayOfWeek.ToString.Trim.Equals(“Monday”) AND row(3).tostring.equals(“W1”)

after that? :wink:

Inside If activity you can include your logics.

thanks man :blush: