How do i convert date (as in my input file provided by client) to the date format as required in the application using uipath?

[Mallika (Mallika Banerjee)]

1. Format in the client file
   

2. Application Requires:
   

How do I convert 1 into 2?

[pllo2ptk (Swoodie)]

Please look at this:

Standard date and time format strings

you parse string with method - DateTime.ParseExact(,<dateformat (look link)>, provider)
Example DateTime.ParseExact(“01/01/2018”, “dd/mm/yyyy”, system.globalization…)
In this way you can parse frm string to date.

[Mallika (Mallika Banerjee)]

@pllo2ptk

DateTime.ParseExact(,<dateformat (look link)>, provider)
Example DateTime.ParseExact(“01/01/2018”, “dd/mm/yyyy”, system.globalization…)

Thanks for your reply. Can you please be little more specific and confined to my requirement.

[ClaytonM]

Hi.
If it’s in the Data Time format, which you can use either CDate() or the ParseExact(), then all you need to do is format it the way you want.

Per your requirement, you would use a format like “d-MMM-yyyy hh:mm:ss tt”

datevar.ToString("d-MMM-yyyy hh:mm:ss tt")

I could be wrong though. Regards.