Excel Copilot does not work with dates

[IanHo_SmartsSA]

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.

  

 

[#2]

Do you see any difference if you do not use the ' ' surrounding the column name and filter date?

[#3]

I tried "Filter Log Date that is 2024-06-17" and its the same.

[#4]

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.

[#5]

@Chris_Ferraro 

Finally, what make it works is being "explicit"