[AccessD] MySQL / VBA Now() format

kost36 at gmail.com kost36 at gmail.com
Wed Jan 25 07:34:41 CST 2023

Hi Stuart,
I think that ms access timestump field format depends on my regional
settings which by default is "dd-mm-yyyy HH:mm:ss"
When I use "yyyy-mm-dd HH:mm(or nn):ss" as format on an unboud text field it
works fine. But it doesn't work on the connected via ODBC field. 
It always returns to "dd-mm-yyyy HH:mm:ss"

-----Original Message-----
From: AccessD <accessd-bounces+kost36=gmail.com at databaseadvisors.com> On
Behalf Of Stuart McLachlan
Sent: Wednesday, January 25, 2023 12:33 AM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] MySQL / VBA Now() format

Oops, that should of course be "HH:mm to hh:nn" with colons.

On 25 Jan 2023 at 8:29, Stuart McLachlan wrote:

> try changing HH-mm to hh-nn :)

AccessD mailing list
AccessD at databaseadvisors.com
Website: http://www.databaseadvisors.com

More information about the AccessD mailing list