Mark.S
October 22, 2024, 3:44pm
1
Starting 10/17, my Transactions sheet Categorized Date column (written by AutoCat) looks like this:
2024-10-20T02:36:08-0500
Which is text and Format as Date doesn’t change anything, because it is not recognized as a Date.
Previously, the cell content looked this and is recognized as a Date:
10/16/2024 2:36:13
Anyone else seeing this?
1 Like
KyleT
October 22, 2024, 8:57pm
2
Hi @Mark.S - Yes I see that behavior in my sheet also starting also from 10/17.
1 Like
Mark.S
October 22, 2024, 9:49pm
3
I have received confirmation that it’s a bug. I don’t have an ETA for the fix.
And here is a formula that could be used in another column to create the corrected value that could then copy-paste values over the bad one:
=DATEVALUE(MID(Z2, 1, 10)) + TIMEVALUE(MID(Z2, 12, 8))
Where Z2 is the Transactions sheet Categorized Date column.
3 Likes
I see it also, starting 10/17. Is there any harm in leaving it that way? It doesn’t seem to have caused any problems for me.
Mark.S
October 23, 2024, 3:15pm
5
AFAIK, there isn’t something that depends on it being a real date, but it’s easy enough for me to correct them to the intended date data. I’ll probably wait to correct them myself until after I see the fix go live, and then just do them all at once in batch.
2 Likes