Renaming a file when I only know part of the filename

Hi,

I am a UNIX newbie. I need help renaming a file when I only know part of the filename. I know the file will look like:

My_report_"YYYY_MM_DD_timestamp".csv

I get a copy of the report each day with the timestamp of when the file was created. I know it is created each day, but the timestamp can vary. I want to FTP the file to another directory and remove the timestamp portion so the resulting file would look like

My_report_"YYYY_MM_DD".csv

I tried setting up some variables for date, but when I try to use them I get

My_report_date not found instead of it translating to the variable I setup as

My_report_2012_10_16

Please help.

Thanks,
~Rehlow

What about something like




?

That worked. Thanks. With my prior attempt I was declaring my variable incorrectly (that's what I get for borrowing someone else's code).

Thanks again,
~Rehlow