To filter data within a specific date range using OData functions, you can apply the date function to retrieve submissions based on a particular date. please resolve the solution
......../Submissions?$filter=start ge datetime'2023-09-22' and end le datetime'2023-09-22' i tried this query its showing
"message": "The given OData filter expression references fields not supported by this server: start at 0",
} error. please help to fix the query
Welcome to the forum! When you have a moment, please introduce yourself in the Introductions thread and consider adding a profile picture. This will help build community!
Try changing your query to something like:
.../Submissions?$filter=__system/submissionDate ge 2023-11-13T00:00:00.000 and __system/submissionDate le 2023-11-17T00:00:00.000
__system/submissionDate is a known system property of Submission that can be used in OData filters with the
ge comparisons you have discovered.
end are probably something you saw in a Central URL but that is separate from the OData API.)
I don't think you need
datetime in your query.