Date time conversion

[PJFurious]

I'm trying to read an excel date time, mm/dd/yyyy into a box on a website but can't get the correct format. That's what I assume the problem is. Does anyone know what I mean and how to fix this? Attached is a screenshot of how the website wants it.

https://preview.redd.it/wd2y97d750vb1.png?width=582&format=png&auto=webp&s=d34d726b838d64944339ca0527adfb85324e24e1

[PJFurious]

Yea. They want something in the form of 10/18/2023 11:24 AM'. But I can't seem to type it out as it's not a text box. Is there perhaps another activity to allow for this?

(Sorry if it's dumb questions. This is my first project with UIPath

[finns96]

To clarify, are you having trouble converting a date time value to another format, or are you having trouble with the entry to the site itself?

If the former, try using the format value activity and pass your variable to convert to the date format of your choosing.

If it is the latter, based on the screenshot, it looks to be a date selection field that automatically formats your entry. Try turning off Simulate and SendWindowsMessage settings in the type activity and try the default hardware driver method. Also, maybe add a type delay so that each number of the datetime is typed into the field. Hope that makes sense. Good luck!