could you help me to solve how I can have the date and time that is in the same box of the excel take me to take them in two different boxes on the page
could you help me to solve how I can have the date and time that is in the same box of the excel take me to take them in two different boxes on the page
First read the data from each cell and split it based on space as delimiter.
Eg. inputStr = “28/01/2020 19:37”
dateStr = inputStr.Split(" “c)(0)
timeStr = inputStr.Split(” "c)(1)