Forum Discussion
Excel Copilot does not work with dates
My worksheet Column B is Log Date Using system suggested prompt: Show items with 'Log Date' of '2024-06-14' Or I tried: Filter Log Date that is 2024-06-17 Almost all the time it doesn't w...
Do you see any difference if you do not use the ' ' surrounding the column name and filter date?
- I tried "Filter Log Date that is 2024-06-17" and its the same.
I check its filter results again. I think Copilot has trouble with date format conversion.
It thinks it read the format right but actually not.
