spfx rest api $filter date query

Question

I added $filter date query to retrieve items "expire_date" greater than today.

this.props.httpClient.get(`.../items?&$filter=expire_date ge datetime ` +  Date.now() + `&$top=10`,
      SPHttpClient.configurations.v1)

I tried Date.now().toString() also see same exception in console;

../items?&$filter=StartDate%20ge%20datetime%201486023536535&$top=10 400 (Bad Request)

In ReactJs, i can get current date with Date.now(), but cant figure how to use it correct format in filter query

Gautam Sheth · Accepted Answer · 2017-02-02 08:31:17Z

1

Try it as below:

this.props.httpClient.get(`.../items?&$filter=expire_date ge datetime ` +  new Date().toISOString() + `&$top=10`, SPHttpClient.configurations.v1)

It should be as :

"/_api/lists/listname/items?$filter=Created ge datetime'" + new Date().toISOString() + "'"

answered Feb 2, 2017 at 8:31

Gautam Sheth

31.1k1 gold badge37 silver badges65 bronze badges

1 Answer 1