"in the last" Operator Missing From Filter Options For a Date

[AKRRMapGuy]

Am I losing my mind? Why can't I filter by 'In the last' on this date field. The operator isn't even showing. I have done it before. What am I missing?

I am trying to do this on EB in Enterprise 11.3. I have other EB apps that have this option on date fields. For some reason this one doesn't.

[TonghuiMing]

@AKRRMapGuy 

The four date-related operators are only applicable for AGO-hosted feature services. Check the documentation here:

https://doc.arcgis.com/en/experience-builder/latest/configure-widgets/filter-widget.htm#ESRI_SECTION... 

The reason, FYI, is that other data sources may not honor the timestamp so that's why there is a limit.

[AKRRMapGuy]

Well, interestingly enough this is a Feature Service Hosted in AGOL being brought into Enterprise VIA a Distributed Collaboration that references the AGOL item.

I guess I am confused about why other data sources possibly not honoring the timestamp prevents a query in Experience Builder? If the data source is valid, it should do it. That is a bizarre and frustrating limitation. 

[TonghuiMing]

To be more specific, it is because, for AGOL-hosted databases, it is certain that CURRENT_TIMESTAMP is UTC. However, it is not certain that this is the case for other databases. It is not a limit from Experience Builder, it is a limit from the service side.

Hope that could clarify it better.