Change month into date

[guptasweb]

Hi
I want to change the all the month name i.e jan,Feb,Mar,Apr,May,June,April,May and so on into 01/01/2022,02/01/2022,03/01/2022,04/01/2022,05/01/2022 and so on. how to write into excel file.
Thanks in advance

[Gokul001 (Gokul Balaji)]

It quite confusing, Can you tell us more detail about your query @guptasweb ?

[guptasweb]

this is my input file

when i am entered the data the month name should be like this 01/01/2022 and so on

[guptasweb]

how to change all the month name?

OUTPUT SHULD BE LIKE THIS

[Yamatendo (Constant Roux)]

Hello,

You can try this Date.ParseExact(YourMonth,“MMM”,System.Globalization.DateTimeFormatInfo.InvariantInfo).ToString(“MM-dd-yyyy”)
With “YourMonth” var the month you wanted with char
Jan for January, Feb for february and so on

[guptasweb]

If i want to extract all the month name, then how to do it?

[Yamatendo (Constant Roux)]

You do a read range of the first line of your excel file (A1 to L1)
For each value, you apply what i gave you earlier and you rewrite your transformed header in excel

[Gokul001 (Gokul Balaji)]

HI @guptasweb

You can try with Write cell activity

DateTime.ParseExact("Jan","MMM",System.Globalization.CultureInfo.InvariantCulture).ToString("MM-dd-yyyy")

Regards
Gokul

[guptasweb]

for every month I should write DateTime.ParseExact(“Jan”,“MMM”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MM-dd-yyyy”)
this query?

[Rahul_Unnikrishnan]

@guptasweb

Try with Modify Date activity.

Thanks

[guptasweb]

Finally I got the solution,I have used switch activity for this.

[Aleem_Khan (crazy bot)]

Which solution work for you ?