Dear support,

On the copy files task where it's possible to specify the "Created older than date" on the Date tab,

Entering {DATENOWADD(Days|-7|dd-MM-yyyy HH:mm)} in the field is acceptable,

however {DATENOWADD(Days|{USERVAR(ArchiveDays)}|dd-MM-yyyy HH:mm)} where the variable is set to -7, gives an error of "Field 'Older than' value is invalid date".


This same formula is working elsewhere in the task, just not in this field.


Kind Rgds


Graham

We tested your Variable and it is working here. Not sure what the problem is. I assume it is a Variable of String type?

---

Hi Support,

No, its of type int32 and is set to -7, - it's working elsewhere in the task with the same formula.

If its of help, the prior task actaully sets it to -7.

I am using version 5.7.9

Graham

We tried with Integer too. Not a problem. Try recreating the Task (maybe there is some junk characters or blankspace somewhere).

---

Hi Support,

I've tried this on 2 different servers.

Am sending you the jobs and variable export by seperate email.


Graham

We see the problem now. Unfortunately there is no easy fix for this right now. Variables are special in that place because they really need to return a date value type - not a string. In the current implementation, mixing with other Variables, at this particular place, causes problems.

I am moving this topic to Feature requests so we can think of solutions for this in the future.

---