Hi People.
I want to enter a value into a combo box on a webpage. I can access the combo box no problem and enter a value. ... my issue is the value is a date and needs to be entered in a certain format which is dd-mm-yy. However as this range changes on a daily basis i cannot put
.document.getelementbyname("datefrom")(0).value = 01-01-01 (as this changes)
i need to do something like
.document.getelementbyname("datefrom")(0).value = worksheets("sheet1").range("a1") (to allow for the change)
however this picks up the time and other infomation regarding todays date when i only want it in my format.
Is anyone able to help me correct my date format into that of dd-mm-yy so i can enter this into my combo box
I want to enter a value into a combo box on a webpage. I can access the combo box no problem and enter a value. ... my issue is the value is a date and needs to be entered in a certain format which is dd-mm-yy. However as this range changes on a daily basis i cannot put
.document.getelementbyname("datefrom")(0).value = 01-01-01 (as this changes)
i need to do something like
.document.getelementbyname("datefrom")(0).value = worksheets("sheet1").range("a1") (to allow for the change)
however this picks up the time and other infomation regarding todays date when i only want it in my format.
Is anyone able to help me correct my date format into that of dd-mm-yy so i can enter this into my combo box
