Getting a file with a dynamic date in the name

I am trying to retrieve a file that we get everyday with the date in the name. example filename070308.DAT

Is there a way to get the computer date to a variable in the yymmdd format and ues that in the filename??

Please see example.