Top 1 or Max in Query Builder

It is possible to use a "Max" or "Top 1" function to get the latest/largest value in a field.  Whenever I add that function to the where section in Query Builder, it no longer allows me to save.

According to the latest documentation for the Query Definition it is possible, but those screenshots are from an older version of Innovator.

https://aras.com/wp-content/uploads/2025/06/Aras-Innovator-2025-Release-Query-Builder-Guide.pdf

I am attempting to get only the latest CE_ManufacturerPartDetail entry based on the latest Synchronization date.  It is not being used in a TGV so I can't limit the execution to one and use sorting to get the latest.

I can get past all of the errors with the following but it does not allow it to be saved.  The button is greyed out.

[Synchronization Date] = max([Synchronization Date])

This is on Aras Innovator version 22.

Any help would be appreciated.