Strong parsing of a string to Date in MM/dd/yyyy format

[Aakash_Singh_Rawat]

Hi guys,

I have a excel sheet having date in dd/MM/yyyy (01/04/2022) and MM/dd/yyyy (04/01/2022) both format.
I want to strong parse these to MM/dd/yyyy whether it is already in MM/dd/yyyy format or any other format.

[GT_Ropa (Hubert Ropa)]

Hi @Aakash_Singh_Rawat

Try using format cells activity.

[Sudharsan_Ka]

HI @Aakash_Singh_Rawat

Checkout this expression

DateTime.ParseExact("Your date variable",{"dd/MM/yyyy","MM/dd/yyyy","Any other formats"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("MM/dd/yyyy")

Regards
Sudharsan

[Sudharsan_Ka]

@Aakash_Singh_Rawat

DateTime.ParseExact(CurrentRow("DateColumn NAme").Tostring,{"dd/MM/yyyy","MM/dd/yyyy","Any other formats"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("MM/dd/yyyy")

You can check and add any other formats inside those {“Other format 1”,“Other format 2”}

Regards
Sudharsan

[Gokul001 (Gokul Balaji)]

HI @Aakash_Singh_Rawat

You can try with strong Date Parsing

DateTime.ParseExact("Jan 01, 2022",{"MMM dd, yyyy","MMM d, yyyy","dd/MM/yyyy","MM/dd/yyyy"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("MM/dd/yyyy")

Output

Regards
Gokul

[Gokul_Jayakumar (Gokul Jai)]

@Aakash_Singh_Rawat

I have a excel sheet having date in dd/MM/yyyy (01/04/2022) and MM/dd/yyyy (04/01/2022) both format.
I want to strong parse these to MM/dd/yyyy whether it is already in MM/dd/yyyy format or any other format.

Hello @Aakash_Singh_Rawat
You can use format cell activity in modern activity

If you are a classic user, follow this

1. Click Filter in activities,
2. Enable the Show modern, you can see the modern activities.
   

[Gokul001 (Gokul Balaji)]

Check out this tutorial @Aakash_Singh_Rawat

[Part 1] Modern Activities - Find/Replace Value | Format Cells

Hello Everyone, Hope you are doing good I would like to present this post who are looking for the Modern Activities Very first thing is to Enable the Modern experience (from Classic) Go to → Activities Panel → Click on Filter → Select Show Modern. [image] Let Jump into the Tutorial we are look into some Modern activities Find/Replace Value Format Cells Note : We need to use Excel Process Scope and Use Excel File for all the above activities Excel Process scope Use Excel File …

[Rahul_Unnikrishnan]

Hello @Aakash_Singh_Rawat

You need to loop through the excel and then use the Format cellss activity. You can set the required format in the format cells activity.

Another approach is using the FoRMAT Range activity.

Format Range

Thanks

[Aakash_Singh_Rawat]

Thank you @GT_Ropa,
It worked.

[Aakash_Singh_Rawat]

Thank you @Gokul_Jayakumar. It worked.