<div>
DateTime columns are not stored in a format. &nbsp;What matters is that it correctly knows the correct date and time value so that when retrieved it displays correctly in your application formatted as &quot;mm/dd/yy&quot;.
</div>


DateTime columns are not stored in a format.  What matters is that it correctly knows the correct date and time value so that when retrieved it displays correctly in your application formatted as "mm/dd/yy".

<div>
mw,<br />
<br />
Yes, I would think so too, but its throwing me a &quot;Type Mismatch&quot; error.
</div>


mw,

Yes, I would think so too, but its throwing me a "Type Mismatch" error.

<div>
Oops! (smacks head!).<br />
<br />
It works, I just had two lines transposed. &nbsp;Thanks!
</div>


Oops! (smacks head!).

It works, I just had two lines transposed.  Thanks!

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I'm using a parameterized query to import a record from my MySQL Database into Access. &nbsp;I want the date to be formatted as, &quot;mm/dd/yy&quot;, but I'm not sure of the Constant to use in my .CreateParameter statement. &nbsp;I tried this:<br />
<br />
.Parameters.Append .CreateParameter(, adDBDate, adParamInput, , Format(Date, &quot;mm/dd/yy&quot;))<br />
<br />
but that doesn't work since the format for adDBDate is &quot;yyyy/mm/dd&quot;.<br />
<br />
How can i do it? &nbsp;It is important that I store the date in the format I specified.<br />
<br />
Thanks!
</div>
</div>


Hi,

I'm using a parameterized query to import a record from my MySQL Database into Access.  I want the date to be formatted as, "mm/dd/yy", but I'm not sure of the Constant to use in my .CreateParameter statement.  I tried this:

.Parameters.Append .CreateParameter(, adDBDate, adParamInput, , Format(Date, "mm/dd/yy"))

but that doesn't work since the format for adDBDate is "yyyy/mm/dd".

How can i do it?  It is important that I store the date in the format I specified.

Thanks!

Need help with importing Date() using parameterized query...

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.