Bot is typing mm/dd/yyyy hh:mm:ss even if I am reading mm/dd/yyyy from Excel

I am reading mm/dd/yyyy from excel as a Date. But bot is typing mm/dd/yyyy hh:mm:ss in the website.
How to resolve that please help.

Excel formats information, so what you see is not always the true value of the cell.

I would guess that the actual value in the cell is "mm/dd/yyyy hh:mm:ss" but you’re only seeing the date portion in Excel because of the format. To get around this you can type myVar.Split(" "c).First which will split the variable by space and take the first item, which should just be mm/dd/yyyy.

myVar.Split(" "c).First is it correct?

@DanielMitchell You are a saviour :slightly_smiling_face::heart:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.