Different date format

[helpplease]

Hello, the top 5 cells are in General and the bottom 4 are in Date format in excel. How do I change them to date/month/year?

[pravallikapaluri]

Hi @helpplease

Use Format cells activity

[Parvathy (PS Parvathy)]

Hi @helpplease

Try this syntax:

DateTime.Parse(CurrentRow("column name").ToString, System.Globalization.CultureInfo.InvariantCulture, DateTimeStyles.None)

Hope it helps!!

[helpplease]

What do I type for the Range? Is there an example?

[rlgandu (Rajyalakshmi Gandu)]

@helpplease

Read the excel
Take for each loop
Date_Format:String
Date_Format=CurrentRow(“Date”).ToString
Assign:
Format=“d-MM-yyyy”
DateTime var=
DateTime.ParseExact(dateString, format, CultureInfo.InvariantCulture)

[pravallikapaluri]

@helpplease

[helpplease]

it didn’t work

[pravallikapaluri]

@helpplease
Can you check with the datatype by clicking the formatcells manually in the excel. It converted

[helpplease]

the format did not change to day-month-year

[pravallikapaluri]

@helpplease

[helpplease]

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi,
Can you try

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi
My input

My output

My solution

Hope it help you,
Regards,
LNV

[helpplease]

Thank you but what I want is to have a consistent format of the date as date-month-year.

The problem is that the top 5 rows are in date-month-year (28-09-2022) while the bottom 4 rows are month/date/year (9/9/2022).

[pravallikapaluri]

@helpplease
Input

Output

[pravallikapaluri]

@helpplease
Check with the above flow

[Parvathy (PS Parvathy)]

Hi @helpplease

1. Use Assign activity and use below syntax:

strinput= CurrentRow("Clock Date").ToString  (Datatype: System.String)

2. Use assign activity and use below syntax:

arr_input= {"dd/MM/yyyy","dd-MM-yyyy"}     (DataType: Array(String))

3. Use assign Acitivty:

var_DateTime= DateTime.ParseExact(str_Input1.ToString, arr_Input, System.Globalization.CultureInfo.InvariantCulture)     (Datatype: System.Datetime)

4. Print it wherever you want to print using below condition:

var_DateTime.ToString("dd/MM/yyyy")

Check the below workflow with sample input:
Sequence.xaml (7.4 KB)

Hope it works!!

[Parvathy (PS Parvathy)]

@helpplease

Have you tried this. If it’s working fine at your end please matk it as solution so that it will help others in solving their query.

Happy Automation
Regards.