[chaley]

Originally Posted by ownedbycats

program: round(days_between($#filedate, $date))

Using this in template search with value '0' also picks up books with an undefined #filedate. How do I avoid this?

None is often equivalent to zero. Try raw_date('#filedate', -1000000).

EDIT: Also, is there a better way to search that both columns have the same calendar date? MCS failed.

I would format both dates in the same way, for example yyyy-mm-dd (watch out for mm vs MM -- I never remember which is which), then compare the strings.