Saving dates in MS Access

[DC CS]

Hi all,
Using MS Access 365 and have an issue with saving dates.
I am in South Africa, so I need to save the date as "dd-mm-yyyy".
I have tried saving with these formats, but to no avail:

Format(StartDate, "dd-mm-yyyy")
Format(StartDate, "#\dd-mm-yyyy\#")
Format(StartDate, "dd-mm-yyyy")

If I save the date 01-03-2022 and check the table, the date has been saved as 10-11-1894, or 23-11-1894. I save these dates without changing them, and they are saved different than the original.

I did not have the issue before. It started about a week ago. Not sure if anything has changed with Microsoft??



Any advise?

Thanks
Deon

[June7]

Nothing has changed with MS Access that I am aware of.

Dates are actually saved as a double number in a date/time field. The dd-mm-yyyy or mm/dd/yyyy is a display format. Access translates the double number to default display as mm/dd/yyyy. This can be adjusted with regional settings.

Review http://allenbrowne.com/ser-36.html

[Minty]

Dates are stored as decimal numbers in Access the integer portion represents date, the fractional part represents the time.
So by using a format() you are converting a date to a string.

Check your regional settings.
Your Display format is a different thing and will be determined by your regional settings.

Can you display the code used to save the dates?
In VBA code you have to force the date to a specific (American) format mm/dd/yyyy or much more preferably use yyyy-mm-dd , then you are in no doubt what date you are saving when you do a debug.

Format([MyDate],"#\yyyy-mm-dd\#" )

More assistance here: http://allenbrowne.com/ser-36.html

[DC CS]

Thanks guys. I changed the save format to American and the display (regional settings) to dd-mm-yyyy.
All is back to normal.

Thanks for the assistance.
Regards
Deon