Split month and year from them and write into respective columns


#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)


#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


#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.