Restricting a date variable using month-year on XLS

Please be aware, the month-year appearance on a date question only affects how the date is displayed, it does not change the fact that a full date is still being stored. Specifically “2019-06” will get stored as 2019-06-01.

This is especially important if you then use these in any comparison calculation. For example, if you want to check if a date is between Dec 2018 (ie >= 2018-12-01) and January 2019, you’d actually probably want to check against February 2019 (ie < 2019-02-01), since January 2019 is actually stored as January 1 (!) 2019.

2 Likes