Forum Discussion
Teams' list - Issue Tracker not accepting today's date
Hi,
Just tried to play with list and choose to "Issue Tracker" as a playground. But by somehow my first test failed 🙂
So, if I select today's date it gives me an error:
"Please add a date that isn't greater than today"
Do we hit to some limits that Teams does not understand timezones correctly?
Petri-X I have the same issue it seems, firstly the date format is set to US MM/DD/YY instead of DD/MM/YY, and I also cannot select today's date.
Petri-X In column settings you can remove the validation rule. I had the same issue once I have changed regional setting / time zone but this fixed.
the column settings is limited if you're using the issue tracker template pre-made by microsoft steve_carroll
i mean this is crazy. this looks like someone used a >= Today operator instead of just > for this template. So this template is pretty much useless to me.Our timezone is UTC+12 and the out of the box issue tracker was not workable. I was able to remove the Column Validation at least.
Petri-XI just encountered this problem today too. So it's still not fixed...
An easy solution, as a few have suggested, is to go into the Column Settings > Edit > More Options > Column Validation and changed the formula from=DateReported<=TODAY(). <- wrong
to
=DateReported<=TODAY()+1 <- not accurate, but good enough
for "Please add a date that isn't greater than today."
