<div>
You can do a direct numeric conversion:<br />
<br />
<br />
MyDate: DateSerial([YourNumField] Mod 10000,[YourNumField]\10000<wbr />00,[YourNu<wbr />mField]\10<wbr />000 Mod 100)<br />
<br />
/gustav<br />

</div>


You can do a direct numeric conversion:


MyDate: DateSerial([YourNumField] Mod 10000,[YourNumField]\1000000,[YourNumField]\10000 Mod 100)

/gustav


<div>
gustav, <br />
<br />
Great use of Mod<br />
<br />

<pre><code id="code-20-35770297-1">? DateSerial(9012011 Mod 10000,9012011\1000000,9012011\10000 Mod 100)
9/1/2011 

? DateSerial(CDbl(&quot;9012011&quot;) Mod 10000, CDbl(&quot;9012011&quot;)\1000000,CDbl(&quot;9012011&quot;)\10000 Mod 100)
9/1/2011 


? DateSerial(10012011 Mod 10000,10012011\1000000,10012011\10000 Mod 100)
10/1/2011 

? DateSerial(CDbl(&quot;10012011&quot;) Mod 10000, CDbl(&quot;10012011&quot;)\1000000,CDbl(&quot;10012011&quot;)\10000 Mod 100)
10/1/2011 </code></pre>
</div>


gustav,

Great use of Mod



? DateSerial(9012011 Mod 10000,9012011\1000000,9012011\10000 Mod 100)
9/1/2011 

? DateSerial(CDbl("9012011") Mod 10000, CDbl("9012011")\1000000,CDbl("9012011")\10000 Mod 100)
9/1/2011 


? DateSerial(10012011 Mod 10000,10012011\1000000,10012011\10000 Mod 100)
10/1/2011 

? DateSerial(CDbl("10012011") Mod 10000, CDbl("10012011")\1000000,CDbl("10012011")\10000 Mod 100)
10/1/2011 

<div>
Yes, Mod is very useful in some cases.<br />
<br />
/gustav
</div>


Yes, Mod is very useful in some cases.

/gustav

<div>
<div class="content wysiwyg-content">
I want to take a numeric 8 digit field that holds a number representing a date mmddyyyy, but where the month ranges from 1-9 the number is stored as mddyyyy. &nbsp;I want to convert this into a date field in a query. 
</div>
</div>


I want to take a numeric 8 digit field that holds a number representing a date mmddyyyy, but where the month ranges from 1-9 the number is stored as mddyyyy.  I want to convert this into a date field in a query. 

Converting a numeric field into a date

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.