The variable is being re-evaluated every time. That's why you need to calculate it once (in a script task or execute sql task) and store the result in a variable, instead of using an expression on a variable.

Or calculate the filename to the date level, it will most likely stay the same.