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!

Moved to Office Development forum

Something like:

VB Code:

DoCmd.OutputTo acOutputReport, "My_View", acFormatRTF, "c:\Test\0205" & Format(Date, "mm-dd-yy") & ".rtf", True

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!