[AccessD] MySQL / VBA Now() format

[kost36 at gmail.com]

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"
Thank's


-----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
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com