Extraneous space in DATETIME_DIFF units parameter greatly skews results


#1

OK, so, strictly speaking not a bug, but certainly an infelicity. :slight_smile: 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:
datetime_diff-bug

Thanks!


Problem in my Nested IF-THEN-ELSE statement