Hi All, I want to separate month and year from Date column and write month in “Month” Column And Year into “Year Column” MonthYear.xlsx (8.1 KB)

Main.xaml (10.3 KB) See attached workflow

Thank You its working:grinning:

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 fo…

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…

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

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

please use my updated file Excel.xlsx (136.2 KB)

Excel split month and year from date

Help

indra (Indra) July 18, 2018, 1:12pm 24

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

Split month and year from them and write into respective columns

Get datetime value from different date format from Excel

Topic		Replies	Views
Split month and year from them and write into respective columns Help	10	1760	July 18, 2018
Excel data mapping Help	4	1733	July 4, 2018
Extract number from date Help	13	1268	August 4, 2020
Extract data from the excel of the input month Help datatable , excel , activities , question	8	945	January 8, 2020
Split text (string) Activities excel , orchestrator , activities , studio , question	1	1026	July 19, 2021

Excel split month and year from date

Related topics