Save file with date stamp
Hi guys,
I'm using the OutputTo function to save a report out of Access and need to save the name with a number and the current date stamp plus in this format "mm-dd-yy.rtf". Here's my OutputTo line that I'm using:
VB Code:
DoCmd.OutputTo acOutputReport, "My_View", acFormatRTF, "c:\Test\0205.rtf", True
So I need my filename to be 0205-MM-DD-YY.rtf. My brain is fried for today and I can't figure this out. Thanks!
Re: Save file with date stamp
Moved to Office Development forum
Re: Save file with date stamp
Something like:
VB Code:
DoCmd.OutputTo acOutputReport, "My_View", acFormatRTF, "c:\Test\0205" & Format(Date, "mm-dd-yy") & ".rtf", True
Re: Save file with date stamp (Resolved)
Quote:
Originally Posted by Bruce Fox
Something like:
VB Code:
DoCmd.OutputTo acOutputReport, "My_View", acFormatRTF, "c:\Test\0205" & Format(Date, "mm-dd-yy") & ".rtf", True
Thanks!