Date Time format changed multiple times

[Pardeep_Malik]

If date format changed within minutes for that what we can use? Like convert to datetime(“dd,MM,yy”)

[Parvathy (PS Parvathy)]

Hi @Pardeep_Malik

Use an Assign activity to set your original date string and format:

originalDateString = "16,09,23 15:30:00"
originalFormat = {"dd,MM,yy HH:mm:ss","MM/dd/yyyy","M/d/yyyy"}

Use another Assign activity to parse the original date string into a DateTime object:

parsedDate = DateTime.ParseExact(originalDateString, originalFormat, System.Globalization.CultureInfo.InvariantCulture)

Finally, use a third Assign activity to convert the DateTime object to the new format:

newFormat = "dd,MM,yy"
newDateString = parsedDate.ToString

If your originalFormat variable keeps on changing then store all kind of time formats in an array and proceed with below process.

Hope it helps!!

[Anil_G (Anil Gorthi)]

@Pardeep_Malik

Is the datetime format changing frequently or the datetime vaue is changing?

If format is changing and if we have all the details about what all formats can come then use

Datetime.ParseExact(datestrvariable,{"MM/dd/yyyy","M/d/yyyy","MM/dd/yyyy HH:mm:ss"},System.Globalization.CultureInfo.InvariantCulture).ToString("dd,MM,yy")

This will give you the converted stirng type date in the required format…and if formats increase you can add more…as of now I added three formats in between flower brackets

Hope this helps

Cheers

[Palaniyappan (Forum Leader)]

Hi

We have a knowledge base on this
I would recommend to have a view on it for compete details

All about Datetime - UiPath

Hi All, My recent post on datatable [All About Datatable- UiPath] (All about Datatable - UiPath) was received well in forum with great feedbacks and many suggested to provide some tutorial on topics which are discussed often in our forum In regards to that I would like to share the commonly used expression for DATETIME conversion Let’s get started one by one 1. Get Current Date in string format Datetime.Now.ToString() (Output - string type - “dd/MM/yyyy hh:mm:ss”) **To get only current da…

Hope this helps

Cheers @Pardeep_Malik

[neha.upase]

Hi,

Use DateTime.ParseExact function to convert the date from its current format to a DateTime object.

originalDate = DateTime.ParseExact(originalDate.ToString, “your_current_format”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yy”)