Hi Chris Popp, thanks for reporting the issue. Currently, the Criteria API doesn’t expose a function like DATEDIFF, though we already support timestampadd, timestampdiff (and dateadd, datediff as synonyms) in HQL.

We plan to make this functions available through the custom HibernateCriteriaBuilder interface, like we already did for datetime truncation.