Time From Field In Text Widget

[AKRRMapGuy]

Has anybody else encountered an issue with displaying a dynamic date/time value in a text widget causing an unwanted conversion to happen? The data is in a Referenced Feature Service living in Alaska Standard Time, and the timestamp matches in the table everywhere, including map viewer, SDE and EB. Alaska Time is also set as the 'preferred' time zone on the Feature Service. 

I am trying to display the most recent time value in the text box using a Max(date) query. It does display the correct value but applies an unneeded/incorrect shift to an unknown time zone (not UTC). For example, 4pm is being changed to 8am on the same day. A -8 hour shift is being applied *only* in the text widget. The Table widget for the same service and field displays the correct time, as does the map Pop-up and Feature Info widgets.

I have tried changing the time settings away from 'Device' in the project settings. Even locking the whole project to the correct time zone doesn't do anything. 

What am I missing, or have I found a bug that needs to be logged? 

We are using Experience Builder native to Portal 11.3. 

[Ke_Xu]

Hi AKRRMapGuy,

When querying  Max(date)  in the Feature Service living in Alaska Standard Time,  will the service return the expected results?

Thanks,

Ke

[AKRRMapGuy]

I guess I don't totally understand the question. That is the query that is mutating the displayed value in the text widget, however it does not mutate that same value in any of the other widgets such as Feature Info, Map (pop-up), Table etc.

Do you mean query the whole service by it rather than return just the value in a text format?

[Ke_Xu]

@AKRRMapGuy  https://developers.arcgis.com/rest/services-reference/enterprise/query-feature-service/

or if possible, could share the service?

Thanks,

Ke

[AKRRMapGuy]

I have a ticket open right now. It is likely yet another bug with EB, specifically the Text widget. Unfortunately, I can't share this service publicly.