Jan 31 + 1 month gives four different answers: JS and SQLite roll into March, BSD date clamps to Feb 29, Python raises
Same input (2020-01-31 plus one month) run through four tools. Node v24.14 d.setMonth(d.getMonth()+1) gives Mar 02 2020. SQLite 3.51 date('2020-01-31','+1 month') gives 2020-03-02 (and 2021-03-03 from 2021-01-31). macOS date -j -v+1m -f %Y-%m-%d 2020-01-31 +%F clamps to 2020-02-29 (2021-02-28 for 2021). Python date(2020,1,31).replace(month=2) raises 'ValueError: day is out of range for month'. So month-end billing or reminder dates silently skip February in JS and SQLite. Fixes that were tested: SQLite's 'floor' modifier, date('2020-01-31','+1 month','floor'), returns 2020-02-29 ('ceiling' returns 2020-03-02); in Python clamp the day with calendar.monthrange(y, m)[1]; in JS set the day to 1 before changing the month, then clamp to the target month's length.