I would like to know if the SQL Functions (DateAdd / DateDiff) are available on Azure Search. I could not find examples / docs about it, but they exist on ODATA official doc:
http://cdn.cdata.com/help/RDA/jdbc/pg_sqldatefunctions.htm
In case they are not available, what is the recommended way for date diffs as filters (e.g Age gt 18).
Azure Search does not currently support OData date functions. You can model this particular problem in one of two ways: Either store time spans of a particular unit as integers (for example, age in years), or model everything as DateTimeOffset and just compare between them. For example: DateOfBirth lt 2000-07-03T00:00Z