Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.

Brad C.
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!
Forum information
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.

{DATEADD(Years|14-8-2018 08:25|d-M-yyyy HH:mm|0|d-M-yyyy HH:mm)}

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

Uses Visualcron since 2006.
Scroll to Top