Sitescope file monitor syntax for past dates

We recieved a request to monitor a directory for four files that contain yesterdays date. We have monitors that use date variables for the current date, but this one will always be for the previous day.

The file names are like this:

IMPORT_4001_MM-DD-YY.txt

with the DD always being one day less than the current day (DD-1). How can I put this into an expression for sitescope? I have tried different syntax for [$day$-1] but nothing is working.

Re: Sitescope file monitor syntax for past dates

Take a look at help section - "SiteScope Date Variables"

They mention minutes offset in one of the examples. There may be a $offsetDays as well (not sure). If not, you can just use the offsetMinutes by adding a negative value with the number of minutes in a day.

Re: Sitescope file monitor syntax for past dates

I tried the suggestion above but it is still returning a file not found error.

I am wondering if the $offsetMinutes$ variable is supported for this type of monitor? In the documentation it states that these variables can be used in content match fields. It doesnt say they can be used for file names. I know they work as-is for file names because we have several log file monitors set up that use them. All of the log files that we monitor are current date and time though.

This is a first for us to look for a file with a past date in the name.

Re: Sitescope file monitor syntax for past dates

Yes if I put the actual file name in there the monitor is fine. When I replace the file name with the variables it goes into error. Let me enter the full path here in case I made a typo. Just FYI we have to use IP name instead of DNS name because the server is behind a firewall. All other sitescope monitors work fine with the setup like that.

Re: Sitescope file monitor syntax for past dates

I think I may have figured out why it isnt working. I have a DEV Sitescope server running version 9.5 that I set up the monitor on and it works PERFECTLY. Our production server is version 8.5 and it is the one where the monitor will not work. I guess somewhere between version 8.5 and 9.5 there is a fix that allows this functionality. We are preparing our upgrade to version 9.5 now so at least I know it will work then. Thanks a million for your help!