Getting all records from a certain year using datetime field

Your question may already have an answer on the community forum. Please search for related topics, and then read through the guidelines before creating a new topic.

Here’s an outline with best practices for making your inquiry.

My question:
Hello,
I am a beginner and have some trouble with postman’s syntax. I couldn’t find the answer elsewhere - if it is already there, I will appreciate a link :slight_smile:

I have a table (called event) that contains an ISO formatted date-time field (called eventdate). how can I send a get request to extract all records that occurred in a certain year (2021)?

example from the event table:
{
“url”: “http://localhost:8000/event/1/”,
“field1”: “a”,
“eventdate”: “2022-09-21T08:07:20Z”,
},
{
“url”: “http://localhost:8000/event/2/”,
“field1”: “b”,
“eventdate”: “2022-09-22T13:30:50Z”,
}

I tried
http://localhost:8000/event?year(eventdate)=2021
and
http://localhost:8000/event?eventdate.year=2021

thanks,

This might help