<div>
format(Now,&quot;dd/mm/yy&quot;)<br />
steve
</div>


<div>
You can create any format you want &nbsp;e.g. &quot;mmmm d, yyyy&quot;
</div>


You can create any format you want  e.g. "mmmm d, yyyy"

<div>
<div class="content wysiwyg-content">
For the Life of me I cant find a function to convert a DATE/TIME field to a String<br />
<br />
Im sure I can you a datepart function but that would be ugly.<br />
<br />
But does VBA have a Function to change a standard access date/time to a String?<br />
I know they have the opposite datevalue(September 15, 2005) to 9/15/05<br />
<br />
Thanks for the Help!<br />
<br />
Joe V
</div>
</div>


For the Life of me I cant find a function to convert a DATE/TIME field to a String

Im sure I can you a datepart function but that would be ugly.

But does VBA have a Function to change a standard access date/time to a String?
I know they have the opposite datevalue(September 15, 2005) to 9/15/05

Thanks for the Help!

Joe V

Covert a DATE/TIME to string value in VBA

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.