I believe @tgxworld already fixed this to consider timezone offset via:
and
https://github.com/discourse/discourse-cakeday/commit/15533c48275b5b5d9c79e288996c203093ad4173
EDIT: I am in timezone UTC+5:30 but have an offset of 6 hours, so I am seeing few edge cases for users who created account between 23:30 and 00:00. Looking into it.