Teams' list - Issue Tracker not accepting today's date

Bronze Contributor

Hi,

Just tried to play with list and choose to "Issue Tracker" as a playground. But by somehow my first test failed :)

Unable use date from today.png

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?

5 Replies

@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.

 

steve_carroll_0-1613702346671.png

 

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.

@markuyTPP 

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.

davidhealthshare_0-1618796391963.png

 

@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&lt;=TODAY(). <- wrong

 

to

 

=DateReported&lt;=TODAY()+1 <- not accurate, but good enough

for "Please add a date that isn't greater than today."