HI
once after reading the data from excel with READ RANGE activity use FOR EACH ROW activity and pass the datatable variable as input
–inside the loop use a assign activity like this if the date format we get is like this
dd/MM/yyyy hh:mm:ss
or if its like this
dd.MM.yyyy hh:mm:ss
then in assign activity lke this str_date = Split(row(0).ToString.Substring(0,10),“.”)(0).ToString str_month = Split(row(0).ToString.Substring(0,10),“.”)(1).ToString str_year = Split(row(0).ToString.Substring(0,10),“.”)(2).ToString