Hi,

Has anyone try to delete files that has time criteria as well?

Coz I have to delete file that is based on created date, that is older than yesterday's 8pm.

i only able to do the date part : {DATENOWADD(Days|-1|dd/MM/yyyy HH:mm)}

i tried changing that HH:mm to 20:00 but not successful to delete the yesterday's file created at 19:59 or 19:00 in the test samples (only 2 file samples).

We cannot reproduce this. Please be sure when you open properties of that file that you really look at Created and not Modified.

---

I am trying to do this:

1. Delete files that is of yesterday's before 8pm based on the created datetime.

Thus i came to the variable part where

Delete files
If created date < {DATENOWADD(Days|-1|dd/MM/yyyy HH:mm)}

How do I changed that so that it can suit my case? Thx for replying.

I'd have thought changing HH:mm to 20:00 should have worked.

I have a similar issue with Date filters (see thread 7.1.0 Email Attachment Filters not working ).

Using the test function - if you set it to delete files older than a specific date does the test function list all files??
(not wishing to hijack your thread but just wondering if it's the same issue)

Thanks,

Don

Yes, you can mix values in date like this:

{DATEFORMAT(yyyy-MM-dd 08:00)}

Please note that this is my regional format. You need to use your format which is probably the one you supplied:

{DATENOWADD(Days|-1|dd/MM/yyyy 08:00)}

---

I'd have thought changing HH:mm to 20:00 should have worked.

I have a similar issue with Date filters (see thread 7.1.0 Email Attachment Filters not working ).

Using the test function - if you set it to delete files older than a specific date does the test function list all files??
(not wishing to hijack your thread but just wondering if it's the same issue)

Thanks,

Don

I'd tried with {DATENOWADD(Days|-1|dd/MM/yyyy 20:00)} , but it just won't work. The same thing happen with you too?
the test function only delete certain type of files in a folder.

There is a way of debugging this more. Turn on Extended debugging in server settings. Then run the Task again. In the log_serverDATE.txt there should be some intersting information where all file dates and in-date is compared.

---

My intention is to delete file from a folder if they are created from the previous day created before 8pm. My job will run at 7pm everyday.

However, I do realise that with my setting to {DATENOWADD(Days|-1|dd/MM/yyyy 20:00)}
and manually run the job, say at 4pm, files created 4pm yesterday are deleted. Files created at 5pm are left alone.

Seems like it implies "24 hours" earlier which might not be the case for me.

Please debug it as describe in the previous post.

---