Input file date is written in month form i.e Jan

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:



1 Like

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.

Actually I am copy the data from this input

so how to declare its variable? and assign the value

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.