I have excel as below in that i have to check the date which is more than one time. if it is more that one time i have to sum the debit amount of that dates, please can any one help me regarding this.
Thanks And Regards,
12.xlsx (9.5 KB)
@ryava_santhoshi What do you mean by “which is more than one time?”
- Create a new variable of type Decimal - we’ll call it dec1
- Open the excel and read the entire sheet and save to a datatable - we’ll call dt1
- For each row in dt1:
If CDate(row.item(“Date”).tostring) > YourDateTime
Assign dec1 = dec1 + cdec(row.item(“Debit”).Tostring)
If you don’t have the datetime saved already as YourDateTime, you can instead use the following:
If CDate(row.item(“Date”).ToString > (new datetime(2019,6,25)). Replace the digits inside with the year as a 4 digit integer, month as a 1 or 2 digit integer, and day as a 1 or 2 digit integer
@Kyle in the excel in date column if date is more than one time present then i have to find the sum of debit of those dates…sorry for late reply
please check this workflow…
test.zip (9.6 KB)
The perfect solution @pathrudu thank you so much.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.