As related to the new database functionality in version 12, I am trying to retrieve a specific entity (row) or group of entities (multiple rows) between a date range in an MS SQL database. The database I am looking at has 4 columns,
"SoldDate". How can I construct a query (
EntityFuncton?) to do that?
The equivalent SQL query would have the
WHERE clause be:
WHERE SKUNumber = '1111' AND SoldDate > '2019-05-31 00:00:00.000' AND SoldDate < '2019-09-01 00:00:00.000'
The quick guide can be found: