# HG changeset patch
# User Sascha Wilde <wilde@sha-bang.de>
# Date 1626271363 -7200
# Node ID 5be842692d87d872a2c0189e488729944164913b
# Parent  fbad74acd23fd306d3e2b6fd0c37130147546da3
Revert dates in report template.

diff -r fbad74acd23f -r 5be842692d87 report-templates/data-quality-report.yaml
--- a/report-templates/data-quality-report.yaml	Wed Jul 07 20:11:17 2021 +0200
+++ b/report-templates/data-quality-report.yaml	Wed Jul 14 16:02:43 2021 +0200
@@ -34,9 +34,11 @@
     - type: select
       statement: >
         SELECT to_char(d, 'Month YYYY') AS month, d::date
-          FROM generate_series( '2019-10-01'::date,
-                                now() - interval '1 day',
-                                '1 month'::interval ) d;
+          FROM generate_series( date_trunc('month',
+                                           now() - interval '1 day'
+                                          )::date,
+                                '2019-10-01'::date,
+                                - '1 month'::interval ) d;
       actions:
       - type: assign
         name: column_number
@@ -89,9 +91,11 @@
     - type: select
       statement: >
         SELECT to_char(d, 'Month YYYY') AS month, d::date
-          FROM generate_series( '2019-10-01'::date,
-                                now() - interval '1 day',
-                                '1 month'::interval ) d;
+          FROM generate_series( date_trunc('month',
+                                           now() - interval '1 day'
+                                          )::date,
+                                '2019-10-01'::date,
+                                - '1 month'::interval ) d;
       actions:
       - type: assign
         name: column_number