Re: script crashes on last day of month but works every other day

[neil black]

Hi thanks you for the reply.
I just find it odd that it only crashes on the last day of the month.

My DB looks like this

'2022-05-02', '0', '0'
'2022-05-01', '0', '0'
'2022-04-30', '0', '0'
'2022-04-29', '0', '0'
'2022-04-28', '0', '0'

if the date today is 2022-05-01
select count(*) from meter where date = current_date() + 1;
returns 1 as a result which is correct

the same query on 2022-04-30
select count(*) from meter where date = current_date() + 1;
return 0 yet 2022-05-01 is present
if I try to add that date with a input query i get a duplicate entry error