Hi All, Please provide workflow by using following file. I want to split month and year from date column and write them into “Month” and “Year column” Excel.xlsx (136.2 KB)

[image] Excel split month and year from date Help @SagarSB check attached updated zip file SplitDateFromExl.zip (45.3 KB)

@SagarSB check below file for the solution. dateExcel.xaml (15.1 KB)

hi indra, Its showing the error

@SagarSB what error you are getting its working fine for me

In my sheet i m having huge data… Date column is in between

[image] SagarSB: Source:Get Row Item Message:DateTimeConverter cannot convert from System.Double Source:Get Row Item Message:DateTimeConverter cannot convert from System.Double

@SagarSB change get row item variable to generic type

after making get_date generic it is showing blue error icon for get row item

[image] SagarSB: after making get_date generic it is showing blue error icon for get row item after making get_date generic it is showing blue error icon for get row item

@SagarSB Follow the file which i have uploaded its working i cross checked two times.

Split month and year from them and write into respective columns

Help

indra (Indra) July 18, 2018, 1:45pm 3

Topic		Replies	Views
Excel split month and year from date Help	25	4903	July 19, 2018
Extract number from date Help	13	1275	August 4, 2020
Excel data mapping Help	4	1741	July 4, 2018
Get date from an excel coulumn Help	15	8383	February 21, 2018
Excel Convert Row Value into Date Format Help datatable , excel	10	2588	September 22, 2019

Split month and year from them and write into respective columns

Related topics