Day and month values swapped when displaying date on cell

Question

I've got the following code

Sub test()

my_date = "01/09/2021  7:42"
Worksheets("Sheet1").Range("A1").Value = my_date

End Sub

This returns the following result

Why does it show in the cell "09/01/2021" rather than "01/09/2021" like on my original variable?

Answer 1

Fixed it this way

Sub test()

Dim my_date As Date
my_date = "01/09/2021  7:42"
Worksheets("Sheet1").Range("A1").Value = my_date

End Sub