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:
  1. 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!