Dato format i VBA access

DateTime fields in Access are always stored in the same format. The format you see the dates is governed by the PC's regional settings.

When you insert a date it should be in US format MM/DD/YYYY or YYYY/MM/DD

so #10/6/2018# is actually 6th October 2018

and when you view it (in DK format you see it as 6/10/2018

try inserting as YYYY/MM/DD

?