System date and time

[SarahCPS]

I'm writing a program that copies a database and stores in a new location.<br>
<br>
I would like to be able to add the system date and/or time to the end of the file name of the database.<br>
<br>
Possibe?

 

[DougP]

NewFileName = &quot;Myfile.xxx&quot; & &quot;-&quot; & format(now,&quot;mm/dd/yy&quot <p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[edderic]

What are you looking for ? a procedure for the system date/time ? (Regional locale date settings)<br>
<br>
Eric<br>
<p>Eric De Decker<br><a href=mailto:vbg.be@vbgroup.nl>vbg.be@vbgroup.nl</a><br><a href=

http://members.tripod.lycos.nl/VisualBasicCenter/>

Visual Basic Center</a><br>

 

[MikeLacey]

Sarah,<br>
<br>
Be a bit careful here. It's quite possible to pick up the date and time using the VB Now() function but you should beware of PC's that disagree over what time it is.<br>
<br>
We just moved to taking the time from the Oracle database for all occaision's where we <b>were</b> using Now(). Took me a while to spot the rather subtle error that it introduced.<br>
<br>
Mike<br>
<p>Mike Lacey<br><a href=mailto:Mike_Lacey@Cargill.Com>Mike_Lacey@Cargill.Com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>