Is there a way to use the {DATEFORMAT()} variable with a date other than the current? I am using a loop on some SQL data and want the output filename to be based on the date in the record, not the current date.

Thanks in advance!
-Brad

Hi Brad,
yes you can with a different function: DATEADD with a specific date.

In here you can format your date in the record, and how yo reformat it.
Use a 0 in the addition, as we do not want to add anything to our record date.



In your case the 1st date should be the loop output variable of the record date.

Regards,
Erik

---