Webinar (on-demand): OutSystems and Analytics Integration: A New Strategy to Reduce Costs
WATCH NOW
GET STARTED FOR FREE
GET STARTED FOR FREE
GET STARTED FOR FREE

Discover everything you need to know about Hubway Connect

Try the product online without any installation or purchase commitment
Hubway Connect
Try Online Now

Innovative ways to leverage your data for business outcomes

Find out how Hubway Connect can help you get more value from your OutSystems platform
Hubway Connect

Learn and expand your Hubway Connect knowledge

Deep dive in articles, videos and technical information to maximise its use
Hubway Connect

Start free and expand without surprises

Choose the Hubway Connect offer that best meets your needs and suits your budget
Hubway Connect

We are here to help. Let’s talk.

Connect with us via your preferred channel and we will be happy to answer your questions
Hubway Connect
  1. Home
  2. Knowledge Base
  3. FAQs
  4. Consuming the service
  5. How to filter date attributes using OData?

How to filter date attributes using OData?

The OData query option $filter is used to restrict the set of items returned by a collection. To filter Date, Time or Datetime attributes use the following formats:

  • Date yyyy-MM-dd
    https://host/service/Order?$filter=ExpectedClosedOn gt 2020-06-01
  • Datetime yyyy-MM-ddTHH:mm:ssZ
    https://host/service/Order?$filter=RequiredOn ge 2020-06-01T21:00:01Z
  • Time HH:mm:ss.SSSSSSS
    https://host/service/Store?$filter=OpeningHour le 13:00:00.0000001

 

Click here to check other OData query options and functions supported by Hubway.

Was this article helpful?
Yes No

Related Articles

Need Support?

Can't find the answer you're looking for?
Contact Support
Hubway Connect
No-code. No-hassle. No-delay. One OData Connector.
Twitter Linkedin Youtube
© 2024 Hubway Connect

Company

Product

Agreement(s)

Hubway Connect
No-code. No-hassle. No-delay. One OData Connector.
Twitter Linkedin Youtube
© 2024 Hubway Connect

Product

Use Cases

Resources

Buy

Contact Us