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 work. As shown in attached screenshots.
- Chris_FerraroSteel ContributorDo you see any difference if you do not use the ' ' surrounding the column name and filter date?
- IanHo_SmartsSACopper Contributor
- IanHo_SmartsSACopper ContributorI tried "Filter Log Date that is 2024-06-17" and its the same.
- IanHo_SmartsSACopper 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.