Bug report: Duration in days when spanning over a month is wrong

[bojiwama]

What happened?

The number of days between calculations is wrong.

date(2024-09-06) - date(2024-11-03)
Output: 60
date(2025-02-17) - date(2025-03-17)
Output: 30

The correct output should be 58 and 28.
Other dates may have errors, but some are correct, the following one is correct.
date(2025-02-17) - date(2025-03-16)
Output: 27

The latest version of obsidian and dataview on my windows and android are the same.
I don't know if it's just my problem.

DQL

No response

JS

Dataview Version

0.5.68

Obsidian Version

1.8.9

OS

Windows

[holroy]

When you calculate durations like that, it tries to humanize the output (or something like that) so it calculates the duration in months (and years) and then if we ask for days it does a very sloppy job saying that a month is just this long.

In general, this is an upstream bug of the date library we use. I'll look into providing a supplemental function for this particular situation, as it's not the first time we've encountered this situation.

[holroy]

The full explanation for those interested given in the link below:

https://moment.github.io/luxon/#/math?id=diffs

Now the question becomes, how do we handles these diffs currently, and is there a better way to do this?