The file attachment doesn't take wild cards so you'd need to know the exact file name somehow, there's a number of ways to get that.

As far as date formatting http://msdn.microsoft.com/en-us/library/ms187928.aspx so if you wanted YYYYMMDD CONVERT(varchar, <date field>, 112)

Or to left pad a field, RIGHT('00' + <field>, 2)