Excel split month and year from date

Thank You its working:grinning:

1 Like

Use Excel scope activity within it use get row item activity for the column u want to fetch the date after that
assign a variable
(for fetching day)
1.newdate= rowtext // output of get row item
2.newdateconverted = Left(rowtext.ToString,4)
3.fetchdate = newDate.ToString(“dd”)
similarly do for fetching month and year

1 Like

Hi …
Can you please develope it with updated excel file…

MonthYear.xlsx (8.7 KB)

hi…

Can u please update your workflow using updated file
MonthYear.xlsx (8.7 KB)

Change from row(0).tostring to row(2).tostring
For write cell just indicate the column letter which is D for month and E for year.
Please note that the datatable output column index is 0, so column A = 0, B = 1, C = 2, and so on…

1 Like

You just have to change Cells in Write Range from B & C to D & E that would work and Get Item Row column index would be 2 according to new file

1 Like

ok i will try it

thanks

Hi …
see in my file i m getting follwing result
DAte

please use my updated fileExcel.xlsx (136.2 KB)

please help with my file

Did you change the index of the datatable row?

@SagarSB check attached file is as per your requirement

SplitDateFromExl.zip (8.2 KB)

1 Like

yes…see above screenshot

please use this fileExcel.xlsx (136.2 KB)

Can anyone provide me solution with this file for split month and year and write them into respective columns…

Excel.xlsx (136.2 KB)

Thanks in advance

@SagarSB check attached updated zip file SplitDateFromExl.zip (45.3 KB)

ok thank you…i will check it and let you know

Attached is the updated file

Excel.xlsx (121.0 KB)

1 Like