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.