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.
2018-08-13T17:03:19Z
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
Sponsor
Forum information
ErikC
2018-08-14T06:28:28Z
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.

Regards,
Erik
Uses Visualcron since 2006.
Scroll to Top