Azure search datetimeoffset field add day and filter le datetime.utcnow

Question

I have two fields ( phaseStarted : DatetimeOffset and duration : Int32 ) in azure index and want to add duration to phaseStarted and check it is less than DateTime.UtcNow, is it possible ?

I know I can have another column and fill it once upload document, but want to know about this way, thanks

Answer 1

Apologize for late response! connected with PG on this ask and there’s not a way to do this without adding a new field like the you mentioned.

Suggest you to refer to this document which gives examples of filtering on DateTimeOffsets: OData filter reference

Hope this helps.