Split month and year from them and write into respective columns

Help
1

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)

2

@SagarSB check below file for the solution.

dateExcel.xaml (15.1 KB)

1 Like
3
4

hi indra,

Its showing the error

5

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

6

In my sheet i m having huge data…

Date column is in between

8

Source:Get Row Item
Message:DateTimeConverter cannot convert from System.Double

9

@SagarSB change get row item variable to generic type

1 Like
10

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

11

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

12

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