<div>
<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;format(#7/12/2000 3:11:36 PM#,&quot;mm-dd-yyyy&quot;)<br />
<br />
<br />

</div>




         format(#7/12/2000 3:11:36 PM#,"mm-dd-yyyy")




<div>
<div class="content wysiwyg-content">
how do i convert<br />
<br />
&nbsp; &nbsp; &nbsp;7/12/2000 3:11:36 PM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;to &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 07-12-2000<br />
&nbsp; &nbsp; &nbsp;or<br />
&nbsp; &nbsp; &nbsp;10/25/2000 2:02:29 PM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;to &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10-25-2000<br />
<br />
the basic requirements being 10 characters and dashes as dividers<br />
<br />
using access 2000 at the moment and preferring a Query<br />
<br />
thanks!
</div>
</div>


how do i convert

     7/12/2000 3:11:36 PM                    to               07-12-2000
     or
     10/25/2000 2:02:29 PM                  to               10-25-2000

the basic requirements being 10 characters and dashes as dividers

using access 2000 at the moment and preferring a Query

thanks!

Converting date time

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.