(This is entirely separate of the other excel issue I posted today...)

I have a client we migrated from v3.2 to v4.0. A number of the jobs export information to excel and then email the excel files to various people. I've gotten in the habit of including the date in the file name formula on the excel step. So for example, the filename might be: %CODEEMPL & " Overdue Receivables " & Format(Date, "yyyymmdd") & ".xlsx" -- and then I have the evaluate filename box checked. In v4.0 the year portion works properly but the month and day does not. So the file name it creates is "SM Overdue Receivables 20190000.xlsx". If I cut my code out of the excel step and save it as an actual formula in a prior transform step, and then reference the formula in the filename field on the excel export, it works. The csv export does not have this issue - the format function works just fine there. It is specific to the Excel write step - also, it doesn't matter what version of excel you are exporting to...