<div>
the key part is to not use the seperators in the Format Funtrion ...<br />
<br />
Format(Now(), &quot;mmddyyhhnnss&quot;)<br />
<br />
now add your base filename at the beginning and file extention at the end ... the function I posted makes this a bit easier for me as I have a number of file formats I export to.<br />

</div>


the key part is to not use the seperators in the Format Funtrion ...

Format(Now(), "mmddyyhhnnss")

now add your base filename at the beginning and file extention at the end ... the function I posted makes this a bit easier for me as I have a number of file formats I export to.


<div>
Wowwie. &nbsp;Learn something new every day. 
</div>


<div>
I use yyyymmddhhnnss so I can easily sort my files cronologically but that is just me ... format it however you would like :-)
</div>


I use yyyymmddhhnnss so I can easily sort my files cronologically but that is just me ... format it however you would like :-)

<div>
Thanks Jim Horn and Stevbe. now I know that I have to use &quot;Format&quot;. <br />
<br />
Thanks a lot.<br />
<br />
st
</div>


Thanks Jim Horn and Stevbe. now I know that I have to use "Format".

Thanks a lot.

st

<div>
<div class="content wysiwyg-content">
Hi <br />
<br />
I want to include the date and time of file generation in the file name. How can I keep the mm, dd, yy, hh, mm, ss and delete the characters &nbsp;/ and : from the general format mm/dd/yy hh:mm:ss ?<br />
<br />
<br />
Thanks,<br />
st<br />

</div>
</div>


Hi 

I want to include the date and time of file generation in the file name. How can I keep the mm, dd, yy, hh, mm, ss and delete the characters  / and : from the general format mm/dd/yy hh:mm:ss ?


Thanks,
st


VBA Date character extraction

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.