Many thanks! I tried it, but am getting a syntax error
PG::SyntaxError: ERROR: syntax error at or near “WITH”
LINE 13: WITH date_range AS (
(apologies, I sent a PM to you via that thread before twigging that you and the original author there are one and the same!)