LIST where file.ctime >= date(this.file.day) AND file.ctime < (date(this.file.day) + dur(1 day))
LIST where
file.mtime >= date(this.file.day)
AND
file.mtime < (date(this.file.day) + dur(1 day))
AND !(
file.ctime >= date(this.file.day)
AND
file.ctime < (date(this.file.day) + dur(1 day))
)