Dynamic naming by date when storing

[#1]

Hey guys,

I have made a SQL script that I have scheduled daily in the QMC for it to auto generate a daily file.

The syntax is as you might now between getdate()-1 and getdate(). I store this file as a CSV file in the script, and I want it to add the date aswell in the name.

_$(vL.Client)_day.csv (txt, delimiter is ';');

[swuehl]

Maybe like

Let vToday = Today();

...

_$(vL.Client)_$(vToday).csv (txt, delimiter is ';');

[#3]

Thansk a lot!