I remember how date math is special there. A simple question: 30-01-2024 plus one month - what is the result date?
Well I had to try this in Excel and (after fighting the input format), it gave me
2024-01-30 -> 2024-01-29 2025-01-30 -> 2025-01-28
Polars has an offset-by function which is a bit more explicit about how you want to handle date math. “Calendar date” vs number of days.
Edit: just ran polars and I’m not in love with its answer either.
Well I had to try this in Excel and (after fighting the input format), it gave me
Fun. There is so much ambiguity in what “one month” means.Polars has an offset-by function which is a bit more explicit about how you want to handle date math. “Calendar date” vs number of days.
Edit: just ran polars and I’m not in love with its answer either.