OData filter query

(0) Share

Report

Posted on by SnowShine

hi everyone - i am trying to figure out how to apply filter to OData call based on a date field. I am using the below to get all the data from purchase order lines where CONFIRMEDDELIVERYDATE >= today's date but i am getting "bad data request" error.

any idea how to get this to work?

xyzxyzxyzxyx.ax.dynamics.com/.../PurchaseOrderLines$filter=CONFIRMEDDELIVERYDATE ge now()&cross-company=true

*This post is locked for comments

All responses (2)

Answers (0)

SnowShine on at

Like (0)

Report

RE: OData filter query

thank you add - how do i use a dynamic date in there such as today's date?
add on at

Like (0)

Report

RE: OData filter query

Hello SnowShine,

I think that the function Now() is not supported. I tried this filter and it works:

?$filter=ConfirmedDeliveryDate gt 2017-01-01

But when I try to use now() it shows this error:

Unknown function 'now'.

Note that field names are case sensitive and there is no need for quotes ('') on the date.