Odata Query with Date filters to fetch data from D365FO

[alisag]

Hello All,

I have the following query which is trying to fetch excahnge rates from Exchange Rate Table,

https://sandbox.operations.dynamics.com/data/ExchangeRates?$select=FromCurrency,ToCurrency,StartDate... FromCurrency eq 'USD' 

is it possible to filter data at the fetch time to get data only for last 2 days(StartDate)

Something like StartDate ge Date.ToText(Date.AddDays(Date.From(DateTime.FixedLocalNow()), -2), "yyyy-MM-dd")

 the above filter didn't worked.

[Expiscornovus]

Hi @alisag,

Just to double check, you have tried appending the below $filter query parameter directly after the existing url, correct?

Can you share the full url you tried?

&$filter=StartDate ge Date.ToText(Date.AddDays(Date.From(DateTime.FixedLocalNow()), -2), "yyyy-MM-dd")

[lbendlin]

This documentation is pretty exhaustive and it includes the syntax for relative dates.

Documentation · OData - the Best Way to REST