Problem with datatype column after writing in excel

Hello everyone,

I’m having a problem when i want to write my datatable into excel.
In my datatable i have a column with dates, when I do a log message, every date is correct.
But when i do a write range to an excel file, some of my dates are different.
For example, i have a date 25/10/2019, this date is still correct in excel, but when I have a date like this: 02/09/2019, in my excel i get 09/02/2019.

Does somebody have a solution for this? :slight_smile:

excelcolumn

As you can see on this screenshot, the tekst values are correct, but the 11/05/2019 has to be 05/11/2019 for example.

Fine
Before writing the datatable to excel use a FOR EACH ROW activity and pass the above datatable variable as input and inside the loop
Use a assign activity like this
row(“yourcolumnname”) = “‘“ + row(“yourcolumnname”).ToString

That is we are concatenating the string with a single quotes before

Then now write that back to excel file
Cheers @hansgeeroms

Thanks dude :slight_smile:

1 Like

Cheers @hansgeeroms

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.