How to select MIN/MAX date field?

[nboughton]

I have a table of records that has a date DATETIME field. I need to select the earliest date and the latest date. In raw SQL this would be

SELECT MIN(date) AS first, MAX(date) AS last FROM table;

However with jet there are only min/max funcs for integers and floats and no apparent way to convert a date field to an integer (effectively render it as unix time). How can I do this with Jet?

[go-jet]

@nboughton Thanks for catching this issue.

The issue is fixed now on develop branch, and it will be released during this week as a hotfix.
Two new methods are added (MIN/MAX) that excepts any expression type.
For example: MIN(table.date) or MAX(table.date).