Identify Relevance by File Date

Hi,

I have a fixlet where the presence of a file is used to determine relevance. There are multiple versions of this file out there and I need a certain version, based on a date/time to be the only one that is relevant. Is there a way to target a particular file and target it’s date/time stamp? I have:

exists file “C:\Scripts\lang.xml”

Using something like: exists file “C:\Scripts\lang.xml” where date = 9/2/15

Doesn’t work.

Thanks

(creation time of it, modification time of it, size of it, sha1 of it) of files "C:\Scripts\lang.xml"

Thanks. I tried: (creation time of it) of files “C:\Scripts\lang.xml” = 9/2/15

but it did not work. Where do you insert the date of the file you’re looking for?

Did you try the query I provided in the Fixlet Debugger?

The format of the query you are looking for is something like:

exists files "C:\Scripts\lang.xml" whose(creation time of it = "?????" as time)

You can’t use “9/2/15” as the creation time. That won’t work. You need to find the exact creation time you are looking for to do that, unless you look for files after or before or between a general time frame.

What is your use case?

You should start with a query that returns the actual results and then work with that to build true/false relevance, like what I provided above:

this is awesome! I got it. thanks for the help!

1 Like

i want to automated and not to fix date
thank you

Then take the date off the query and go back to the original “exists file”.