<div>
Assuming &quot;20140101&quot; has been inputed as a date or datetime, then Format(&lt;&lt;field name&gt;&gt;,&quot;yyyy-mm-dd&quot;) should work.<br />
<br />
If it is a string, then Randy's answer is correct.
</div>


Assuming "20140101" has been inputed as a date or datetime, then Format(<<field name>>,"yyyy-mm-dd") should work.

If it is a string, then Randy's answer is correct.

<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
Is there a way to format a date inputted as 20140101 to 2014-01-01 in an SQL statement in MS Access?
</div>
</div>


Experts,

Is there a way to format a date inputted as 20140101 to 2014-01-01 in an SQL statement in MS Access?

Format date in access 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.