Hi Software Engineers,
I’m automating from excel data in which one of column name is Date (2021/10/12) (2022/10/14) like screenshot.I want to loop this date data from website. In this website, 2021年10月12日(each drop down pattern).So , I have to indicate three select item activities. But I created only one variable(strDate).In there, how can I substract this (2022/10/14) from excel.
You can try out the below step to split the string to 3 to extract,day,month and year.
If the Date format in column is fixed
strDate=2020/10/14
Year part for the dropdown=strDate.Split(“/”)(0).ToString
Month part for the dropdown=strDate.Split(“/”)(1).ToString
Day/Date part for the dropdown=strDate.Split(“/”)(2).ToString