WORKAROUND:
If the script was built in TDP 4.1, we will honor the expression as the suffix. If a new one needs to be built, the expression builder is available in the variable activity. Make a variable that builds the suffix expression and then add the variable in the path name.
a = To_char(Current_date(), 'YYYY-DD-MM') C:\Users\username\Documents\ToadExport_#a#.xlsx
STATUS:
This issue is fixed in Toad Data Point 5.0. This version can be downloaded from the downloads section of our website, which you can access by clicking here.