Regional date format when updating recordset in VBA

Question

I'm based in the UK and am developing an Access 2016 DB for a client in the US.

I need to update some dates in a table programmatically and I've done so by editing a RecordSet.

My question is this: If I provide the dates in UK format (dd/mm/yyyy) will the database store it as US format (mm/dd/yyyy) on my clients computers?

I've no way to test this without changing my regional settings in Windows which I'm not keen to do.

Thanks.

Answer 1

You won't provide a format but a value. Formats are for display only.

Dim Date1 As Date

' Set Date1 to some value.
Date1 = DateSerial(2016, 10, 15)

rs!YourDateField.Value = Date1