Date standard
From EXCEL I import a number of dates in format mm/dd/yyyy and they shows up in Access tabel as short text field. I am trying to convert to Danish date standard by copying field to another field with Date/Time as format. If date = 1/13/2021 it ends up as 13-01-2021 and it is OK. But if I receive a date = 1/12/2021 it ends up as 01-12-2021 and it is not Danish short format. It seems to go wrong for all dates where it you can switch MM and DD and still have a valid date in format dd-mm-yyyyt.How can I handle this situation.
Best regards
OMN.