good afternoon, my doubt is that from my excel I read it through the activity, and I extract the values through and
the problem is that the value I need is in this format <25.09.2019 23:41>, what I want is that only the value <20190927> remains, I want to remove the recorded points and time, then set a value of two days later, that’s why it changes from 25 to 27
and finally register it in year-month-day
Hi
Hope these steps would help you resolve this
—use a excel application scope and pass the file path as input
—inside the scope use a READ RANGE activity and get the output with a variable of type datatable named dt
—now use a assign activity like this row(“Fecha”) = DateTime.ParseExact(row(“Fecha”).ToString.SubString(0,10),”dd.MM.yyyy”,System.Globalization.CultureInfo.InvariantCulture).AddDays(2).ToString(“yyyyMMdd”)
This will convert all the row values as per our need
—next use a Write range Activity and mention the input as dt and enable add headers property