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

Help Activities
, ,
1

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?

2

Hi
Code for converting “Jan” to “01” e.t.c:

DateTime.ParseExact("Jan","MMM",Globalization.CultureInfo.InvariantCulture).ToString("MM")

Capture

1 Like
3

where should I write it?

4

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.

5

Actually I am copy the data from this input

image
image885×336 10.7 KB

so how to declare its variable? and assign the value

6

yes,so how to do it?

7

Main.xaml (6.6 KB)
This is xaml file which generating date for each column from excel file
image

8

If i want to write it in a sheet, then how to do it?

9

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

10

it shows an error :11/03/2022 15:05:23 Assign: String was not recognized as a valid DateTime.