MobileRead Forums - View Single Post - End-of-month errors when setting pubdate?

drawson1 · 04-01-2021, 07:13 AM

I generate a couple of different catalog files for my library (including one with "calibredb catalog" ...); when I import those files I set the Publication date. When I ran that script today, it set the pubdate to 02-Apr instead of 01-Apr. A little experimenting shows that the first and last day of the month always seem to be set wrong:

Code:

01-Apr-21 07:04 > calibredb set_metadata 4380  -f pubdate:2021-01-30
Title               : Dan's Catalog
......
Timestamp           : 2021-03-02T00:00:00+00:00
Published           : 2021-01-30T00:00:00+00:00

01-Apr-21 07:04 > calibredb set_metadata 4380  -f pubdate:2021-01-31
Title               : Dan's Catalog
......
Timestamp           : 2021-03-02T00:00:00+00:00
Published           : 2021-01-30T00:00:00+00:00

01-Apr-21 07:04 > calibredb set_metadata 4380  -f pubdate:2021-02-01
Title               : Dan's Catalog
......
Timestamp           : 2021-03-02T00:00:00+00:00
Published           : 2021-02-02T00:00:00+00:00

I tested 28-Feb/01-Mar and 31-Mar/01-Apr. I also tried the syntax "pubdate:"01 Feb 2021", with the same result.

Note that the timestamp field behaves the same way when I use set_metadata, but I see from another thread here that I shouldn't be setting that manually :-)

Thanks!

Dan

04-01-2021, 07:13 AM	#1
drawson1 Connoisseur Posts: 96 Karma: 10 Join Date: Mar 2014 Device: Libra H20, Clara 2E	End-of-month errors when setting pubdate? I generate a couple of different catalog files for my library (including one with "calibredb catalog" ...); when I import those files I set the Publication date. When I ran that script today, it set the pubdate to 02-Apr instead of 01-Apr. A little experimenting shows that the first and last day of the month always seem to be set wrong: Code: 01-Apr-21 07:04 > calibredb set_metadata 4380 -f pubdate:2021-01-30 Title : Dan's Catalog ...... Timestamp : 2021-03-02T00:00:00+00:00 Published : 2021-01-30T00:00:00+00:00 01-Apr-21 07:04 > calibredb set_metadata 4380 -f pubdate:2021-01-31 Title : Dan's Catalog ...... Timestamp : 2021-03-02T00:00:00+00:00 Published : 2021-01-30T00:00:00+00:00 01-Apr-21 07:04 > calibredb set_metadata 4380 -f pubdate:2021-02-01 Title : Dan's Catalog ...... Timestamp : 2021-03-02T00:00:00+00:00 Published : 2021-02-02T00:00:00+00:00 I tested 28-Feb/01-Mar and 31-Mar/01-Apr. I also tried the syntax "pubdate:"01 Feb 2021", with the same result. Note that the timestamp field behaves the same way when I use set_metadata, but I see from another thread here that I shouldn't be setting that manually :-) Thanks! Dan