I want to write date in the 01/01/2022 form but in my input file it is written as Jan.How to convert it?
Code for converting “Jan” to “01” e.t.c:
where should I write it?
For example in assign activity. It is just code wchich convert one string to another (“Feb”->“02”). To generate entire date ‘01/01/2022’ we need also day and year.
yes,so how to do it?
Main.xaml (6.6 KB)
This is xaml file which generating date for each column from excel file
If i want to write it in a sheet, then how to do it?
Main.xaml (7.9 KB)
Workflow which replace column names to correct format. Just use your excel path and excel sheet name in read range and write range activity
it shows an error :11/03/2022 15:05:23 Assign: String was not recognized as a valid DateTime.