# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1626277590 -7200
# Node ID 0d6fb393c79a388012982cb5e9f3d23107c11629
# Parent  4046432ccc9df247379799200e9b668955fae677# Parent  5be842692d87d872a2c0189e488729944164913b
Merged default into marking-single-beam branch.

diff -r 4046432ccc9d -r 0d6fb393c79a report-templates/data-quality-report.yaml
--- a/report-templates/data-quality-report.yaml	Tue Jul 13 18:30:07 2021 +0200
+++ b/report-templates/data-quality-report.yaml	Wed Jul 14 17:46:30 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