Shows all projects with a finish date that lies in a specific month or year, optionally with additional metadata

Show projects finished this month¶

Basic¶

Table finished 
FROM "10 Example Data/projects" 
WHERE dateformat(date(finished), "yyyy-MM") = "2022-07"

Variants¶

Show additional metadata¶

Table project-id, finished, tags 
FROM "10 Example Data/projects" 
WHERE dateformat(date(finished), "yyyy-MM") = "2022-07"

Show all finished projects grouped by month¶

Table rows.project-id AS "Project ID", rows.finished AS "Finished on", rows.tags AS "Tags" 
FROM "10 Example Data/projects" 
WHERE finished
GROUP BY dateformat(date(finished), "yyyy-MM")

Show all finished projects grouped by month of a specific year¶

Table rows.file.link AS "project", rows.finished AS "Finished on"
FROM "10 Example Data/projects" 
WHERE finished AND dateformat(date(finished), "yyyy") = "2022"
GROUP BY dateformat(date(finished), "yyyy-MM")