Problem with dates: day becames month and month becames day.

Options

Hi.


I am facing the following problem with date formats.

In my source sheet, I have the following date: 04/12/20, which stands for 04/December/2020.

An automation copies that value to another sheet, but in that sheet it appears as 12/04/20, which is 12/April/2020.

I am doing anything wrong or is this a bug?

If the day of the date is bigger than 12, it works fine. For example, 30/06/22 is copied as 30/06/22.

Thanks in advance for your support.

Xesús.

Answers