I am having issues with Dates. My Regional settings are setup to UK. My tables Date/Time fields are showing UK examples when set to "General Date". Running VBA code for now() and debug.print is showing the UK style date. If I use Now in a query string the dates are entered into the table as US style 01/11/2023 instead of 11/01/2023 dates. I have tried wrapping the Now() in a format() but that made now difference. I tried saving Now to a variable and then using the variable in the query string but made no difference.
Within the table if I select using date picker the dates entered by the query are showing UK style eg 01/11/2023 date picker show 1st November.
Any help would be much appreciated
Scott Axton
@Reply 3 years ago
Sorry to say but that is a well known issue within Access. Mostly because MS is U.S. based and therefore biased.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
