Hi,
I am trying to move files using an SQL query to get the current location, destination location and a date used so only files older than a date.
I think I have everything sorted except date modified. How do I use the date (or number) from the database to compare with the Modifiled date in the File filter? I tried {LOOP(CurrentValueXArray|1)} but I get a Field 'Older than' value is an invalid date.
What is the best way to do this?
Thanks
Nathan