KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Querying Dates using ORDA
PRODUCT: 4D | VERSION: 19 | PLATFORM: Mac & Win
Published On: December 30, 2021

It is posibile to query a date field using ORDA. This can be done by using the following pattern for the query statment:

Field = YYYY-MM-DD

or

Field = 'YYYY-MM-DD'

In either case, objects can contain dates and will properly type the argument to match the field.
This allows the statement to work if the field is a date type and also if the field is a string type.