OK, so, strictly speaking not a bug, but certainly an infelicity. :slightly_smiling_face: Maybe someone can step on it next time something else needs fixing in DATETIME_DIFF…
For background, see this post in the Support forum.
Specifying 'day ' or 'days ' rather than 'day' or 'days' produces wildly incorrect results:
Thanks!