Some problems when export dates

Question

question

Nil Ns asked Feb 21, '23 Felix Möhlmann answered Feb 21, '23

Some problems when export dates

Hello All,

I am trying to export some data to Excel, but I have a problem with the dates.

I use Model.dateTime.toString("%x") to create the date column in FlexSim:

The date is in format DD/MM/YYYY, the same that the model and the format that I want.

But that's the column in excel, after the export:

As you can see Excel change the format of the first date to MM/DD/YYYY.

When I create a filter, this is what appears:

It seems that Excel has the date saved as March 2 (and not February 3). The other dates are simply interpreted as a string.

Any idea?

Thanks for the support!

Software Version:

FlexSim 22.2.3

excel export datetime

1676973742397.png (1.8 KiB)

1676973858443.png (2.4 KiB)

1676973970677.png (3.2 KiB)

Answer 1 · 2023-02-21T11:09:26Z

Felix Möhlmann answered Feb 21, '23

You could try to use "convert()" to transform the FlexSim datetime into the Excel time format and then export those values.

I don't know if the export would overwrite the column format setting in Excel. But if it does, switching it back to date formatting should result in the correct date.

1676977691509.png (67.6 KiB)

· 2

Nil Ns commented · Feb 21, 2023 at 11:25 AM

Hey Felix,

It works, thanks.

I don't know why but at the same point Excel stop detecting that it is a date and shows the number.

Even so, it is solved if i change the format of the column to date

Thank you so much.

0 ·

1676978645057.png (2.0 KiB)

Felix Möhlmann Nil Ns commented · Feb 21, 2023 at 11:55 AM

Nice to know that I could help. In that case I will change the comment into an answer. It would be nice if you could accept it to let others know the question is solved.

0 ·

question