VBA Selenium Date Input

[ryan8200]

I have issues to sendkeys into date input control using following code. The existing date input content cannot be cleared

[/
    auto.FindElementById("startDate").Click
    auto.FindElementByXPath("//*[@id='calendar']/tbody/tr[1]/td[7]").Click
]

However, it is workable with this code but I would like to automate this step so that I don't have to manually change date position in calendar every time I run the code.

[/
auto.FindElementById("startDate").Clear
auto.FindElementById("startDate").Sendkeys("2021-09-04")
]

 

[John_w]

Do you mean you want the current date?

auto.FindElementById("startDate").Sendkeys(Format(Date, "YYYY-MM-DD"))

 

[ryan8200]

Do you mean you want the current date?

auto.FindElementById("startDate").Sendkeys(Format(Date, "YYYY-MM-DD"))

Hi John not current date, I have the date format in 2021-09-04-12:00 AM. When I send keys , it has been truncated to 2021-09-04-12:0 causing no correct date is selected. Any advise on this scenario ?

 

[John_w]

I have the date format in 2021-09-04-12:00 AM

Assuming this is a string variable named theDate, try:

auto.FindElementById("startDate").Sendkeys(Left(theDate, 10))

I can't really help you further without seeing the web page.