cfernand74
04-11-2014, 08:32 AM
When I use code to transfer date from excel to web form it gets changed from 10/10/2013 to Thu Oct 10 2013 00:00:00 GMT/0400 (Eastern Daylight Time). The input box that the date goes into has popup of a calendar as soon I manually click on the input box. I can manually enter 10/10/2014 even 9/10/2014 and it work the way it should. But with code no matter how I try it I have had no good result.
My thought on possibly solving this is to enter date one character at a time and see if it works via Sendkeys , but i don't know how to do that with code. I need also make sure I make reference to the form and value as below and I don't know where to code the sendkey and make it enter one character at a time. So again whatever date is entered in code is not represented in form correctly unless the website sees it as if it’s being done manually.
The code I currently use to code into text box is:
IE.Document.forms("Form").all("AssessedValueDate").Value = "date"
The HTML code is:
<input tabindex="1000" class="qbo-date scoreitem qbo-date-required validation-failed" id="AssessedValueDate" type="text" value="">
Please help.
My thought on possibly solving this is to enter date one character at a time and see if it works via Sendkeys , but i don't know how to do that with code. I need also make sure I make reference to the form and value as below and I don't know where to code the sendkey and make it enter one character at a time. So again whatever date is entered in code is not represented in form correctly unless the website sees it as if it’s being done manually.
The code I currently use to code into text box is:
IE.Document.forms("Form").all("AssessedValueDate").Value = "date"
The HTML code is:
<input tabindex="1000" class="qbo-date scoreitem qbo-date-required validation-failed" id="AssessedValueDate" type="text" value="">
Please help.