Hi, thanks for your comment
I’ve tried your query and works perfectly, many thanks. Only change I had to make for the query to work is to adapt the dates with dateformat()
since the attributes created and updated are in format yyyy-MM-dd’T’HH:mm
The query is:
TABLE created as Created, updated as Modified,
join(file.etags, " ") as Tags, join(MOC, " ") as MOC
FROM !"0. Journal" AND !"-. Templates"
WHERE dateformat(created, "yyyy-MM-dd") = dateformat(this.file.day, "yyyy-MM-dd")
OR dateformat(updated, "yyyy-MM-dd") = dateformat(this.file.day, "yyyy-MM-dd")