Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Wrong date import from excel file

Hi,

 

The date import from excel is incorrect.

For example, the dates highlighted in yellow has reverse date and month.

Those date from 1 to 12 will become the month instead of the date.

 

Eg: 12/10/2020 shown below is actually 10/12/2020 (12th October 2020).


How to correct this date?