Date format to full length

[438654]

Goodmorning,
I have an date read from excel. Now the date is 11-02-2019 but i need to change it to 11-februari-2019.
Someone can help me with this issue?

[balu (Bharath Yadav)]

HI @438654
please follow below link

How to convert date format from 31-March-2019 to Sunday, March 31,2019

@learie What error it was throwed when you tried it ?

Thanks

[KannanSuresh]

@438654
You can use DateTime.ParseExact("11-02-2019", "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MMMM-yyyy")

[Jan_Brian_Despi]

Hi @438654,
You can use DateTime.ParseExact

DateTime.ParseExact Method (System)

Assuming the date (11-02-2019) is assigned to variable named strDate.
Then you can use the answer @KannanSuresh provided.
But replace the “11-02-2019” to strDate.

Thanks and regards.

[438654]

It’s giving me that it isn’t a valid DateTime

[Jan_Brian_Despi]

Can you upload your workflow here? Thanks

[438654]

Main.xaml (20.7 KB)

[Jan_Brian_Despi]

Please see this example workflow:
Sequence.xaml (4.5 KB)

[438654]

The file contains errors

[Jan_Brian_Despi]

What is the version of your UiPath studio?

[438654]

2019.4.2

[Jan_Brian_Despi]

Can you send a screenshot of the error?

[438654]

This error is also in the other files

[Jan_Brian_Despi]

BlankProcess38.zip (11.2 KB)

[438654]

it is still there

[Jan_Brian_Despi]

Have you tried updating the packages?

[438654]

hmm which one i have to update?

[Jan_Brian_Despi]

[438654]

okay your file is working now. The difference i see is that you assigning an value StrDate to “11-02-2019” my value, for example StrDate, is coming from an Excel file. The value 11-02-2019 is in the excel file with get row. So maybe it’s because the value is an GenericValue?

[Jan_Brian_Despi]

Okay. Good.
Can you use a message box to view the value of the date from the excel file?