Forum Discussion
IanHo_SmartsSA
Jun 25, 2024Copper Contributor
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...
IanHo_SmartsSA
Copper Contributor
I tried "Filter Log Date that is 2024-06-17" and its the same.
IanHo_SmartsSA
Jun 28, 2024Copper Contributor
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.