Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export Filename incorpating a date time stamp 2

Status
Not open for further replies.

DropsIT

MIS
Jun 12, 2003
37
GB
I am trying to export a table to a text file, but the name of the file needs to be date / time stamped as it is continuously run. Can anyone help me with the code for this ? Thanks
 
And what have you tried so far ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
DropsIT,
Format$() & Now()?
i.e. [tt]Format$(now,"yyyyddmm-hhnnss\YourFile.txt") = 20072407-172503YourFile.txt[/tt]
Or at least it did when I pressed enter...

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top