Excel Copilot does not work with dates

Copper Contributor

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.




4 Replies
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.




Finally, what make it works is being "explicit"