I am wondering if anyone has any experience with Velixo which works inside excel and if you can help answer the below question.
I am trying to filter a date from the GI and the array is returning an error. The filter actually goes through correctly and I can see the filter details in the cell, but the query returns a #value error. Below is the valid filter. The last one is the date filter. It shows "and ARMStartdate le 2024-12-31T000:00:00:000Z" in the cell telling me it's valid. Why won't this work. I tried it with another date field and got the same error. The actual dates in the query are in MM/DD/YY format
=GIFILTER("Ithaka","DR-Weekly Sales report","Glaccount",B8:B19,"InventoryID","<>"&"""","Status",C8:C10,"ARMStartDate","<="&"12/31/24")
I am trying to filter a date from the GI and the array is returning an error. The filter actually goes through correctly and I can see the filter details in the cell, but the query returns a #value error. Below is the valid filter. The last one is the date filter. It shows "and ARMStartdate le 2024-12-31T000:00:00:000Z" in the cell telling me it's valid. Why won't this work. I tried it with another date field and got the same error. The actual dates in the query are in MM/DD/YY format
=GIFILTER("Ithaka","DR-Weekly Sales report","Glaccount",B8:B19,"InventoryID","<>"&"""","Status",C8:C10,"ARMStartDate","<="&"12/31/24")
