Format Date in macro

[Guest]

I have a macro that E-Mails a report (sendObject) in the Subject I have the
report name. How can I have the date and the report Name in the subject.
Tried Format(Date, "mm-dd-yy") & "Report Name" but returned just that. Much
Thanks in advance.

 

[Ken Snell [MVP]]

Try
=Format(Date, "mm-dd-yy") & "Report Name"

 

[Guest]

DOLT!!!!!!! Thanks Ken

Try
=Format(Date, "mm-dd-yy") & "Report Name"