filter based on files with date added earlier than date subject created

[David Werier]

Is there a way to find all my files that have a date added that is earlier than date subject created.

Thanks.

[Mario]

This is tricky. You can filter for both dates of course in the Filter panel, but there is no "Compare this with that and when A then B" filter.

You could solve this with a data-driven category. Create one based on a variable expression which compares the both dates and outputs some value, depending on which date is greater.
This data-driven category produces two children, one for all files where date 1 is less than date 2, and one for all other files.

Try this variable, for a start (it's from the Formatting Functions help topic.

{File.Added|format:YYYY-MM-DD hh:mm:ss;datecomp:lt,{File.DateTime|format:YYYY-MM-DD hh:mm:ss},Added Before,Added After}

Copy and paste it into VarToy and see which results you get for files where added < created and where added >= created. If it works, use it to create a category: Data-driven Categories Based on Variables

[David Werier]

Thanks for the quick reply. That works well!