@chaley
That worked up to a point... It definitely visually put the right date dates for the files I cross-checked. But I don't think it puts the date in the column as an actual date. When I tried to search based on dates, I couldn't get any results. I tried to get dates before, dates after, specific dates, and yesterday (I added a new epub yesterday, so there should definitely be a result for that) and couldn't get any results.
I used:
- "Column built from other columns, behaves like tags" column type.
- Your exact code, which definitely displays the correct results
- Search expression (as an example): #epub_last_modified:_yesterday, after trying what I mentioned above and thinking maybe somehow my search expressions were wrong and this had to work. I even tried adding in a quote mark (") before and after the criteria, since that seems to be required for some things, but that didn't work either. I even double-checked the _yesterday with date:_yesterday, and that worked perfectly
Is there something that can make the result a searchable date, or am I missing something (blindingly obvious most likely) in my search?
@davidfor
As you could likely figure out from my comments above, I'm looking to be able to have a searchable (filterable?) list of dates for when the actual files are last modified. I didn't think that was likely doable from one column, which was why I had them separated into 2 columns. Is it possible to have the results produced from your suggestion give me searchable dates? Most specifically in your scenario, I would be looking for it to show me any books of any type returned that haven't been updated since a specific date.