Json-server: Filter by date range

[webcoderkz]

Is it possible filter by date range? I have 2 fields from_date and to_date, is there any way to filter by range?

[realtica]

Is it possible filter by date range? I have 2 fields from_date and to_date, is there any way to filter by range?

Yes, you can use: dateFieldName_gte and dateFieldName_lte
Enjoy!

[elpddev]

This only works for intersection. Meaning from_date =< to_date. dates from 2017 up to 2018.
I am not sure if json-server support cases where you want to exclude a date range. Meaning all dates not in from_date to to_date. ex. dates up to 2017 or dates bigger then 2018.

[felizardo-felipe]

Whats the date format to use for filter?

[ladaniavadh]

gte and lte is not working on date filter
I am want to find data between 24/08/2008 to 24/08/2012 so for between it is not working
it is working for equal only
any solution please

[ciw1973]

@ladaniavadh You'll need to store your date in ISO 8601 format (e.g. "YYYY-MM-DD...") in order to be able to sort and filter properly.

This is standard practice for many reasons, including that it allows simple lexical sorting, and avoids issues with localised date formats.