Save file with date stamp

[CJD#11]

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:

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!

[si_the_geek]

Moved to Office Development forum

[Bruce Fox]

Something like:

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

[CJD#11]

Something like:

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

Thanks!