Hi,
Trying to construct and OData query (Apps10) to look for anything in the past year.
The query does not error in Power Query Editor but it is not seeing the $Filter when I execute.
There are various posts on the community relating to OData Filter issues - can anyone confirm or deny that dynamic date is possible in OData / IFS ‘Flavour’ of OData
let
Source = OData.Feed("https://XXXXint/ifsapplications/projection/v1/CustomerOrderLinesHandling.svc/CustomerOrderJoinSet?$filter=DeliveredQty gt 0&filter=date(FirstActualShipDate) ge "&Date.ToText(Date.AddMonths(Date.From(DateTime.LocalNow()),-12),"yyyy-MM-dd")&"&$top=99&$select=Cf_Delivery_Post_Code,FirstActualShipDate,CustomerNo,Cf_Customer_Name,Cf_Catalog_Group,CatalogNo,CatalogDesc,Cf_Salesman_Code,LineTotalWeight,DeliveredQty,Cf_Order_Type_Desc",null,[Implementation="2.0"])
in
Source
