Hi experts,

i have designed a query to download inventory transaction history.
when i download to excel, some of the row have different format of date.
for example:
Actual Log Date
6/10/2019 14:46
13-06-19 19:14:22
28-06-19 17:24:52
29-06-19 12:13:04
6/11/2019 18:39
6/11/2019 18:39
6/12/2019 11:59
21-06-19 17:17:20
19-06-19 16:26:34
19-06-19 16:28:52

It happen sometimes. Does anyone knows why and how i can prevent it.
it give us trouble same when to do analysis.

Thank you.

Is it that way in the table? Are you using a baan easy sql query or a session(like a report session)?

6/10/2019 14:46
13-06-19 19:14:22


It seems the one which is colored is converted to a proper excel date object.
And the next one is stored as a text object.

Do you have a sample to attach?
Preferably the raw data(Which gets converted to Excel) and the Excel file... where the problem is visible.

Regards,