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


#1
  1. Format in the client file
    image

  2. Application Requires:
    image

How do I convert 1 into 2?


#2

Please look at this:
https://docs.microsoft.com/en-us/dotnet/standard/base-types/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.


#3

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


#4

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.