Forum Discussion

IanHo_SmartsSA's avatar
IanHo_SmartsSA
Copper Contributor
Jun 25, 2024

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_Ferraro's avatar
    Chris_Ferraro
    Steel Contributor
    Do you see any difference if you do not use the ' ' surrounding the column name and filter date?
    • IanHo_SmartsSA's avatar
      IanHo_SmartsSA
      Copper Contributor
      I tried "Filter Log Date that is 2024-06-17" and its the same.
      • IanHo_SmartsSA's avatar
        IanHo_SmartsSA
        Copper 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.

         

Resources