https://community.dynatrace.com/t5/Automations/Davis-output-timestamps/m-p/294275#M2498 <P>Hey all.<BR /><BR />I currently have quite a few workflows that run Davis Anomaly Detection on a schedule. I then parse the Davis output and issue emails if any anomalies are detected via a "Send Emails" workflow task, using the provided filters to check for alerts and format a markdown table of all alerts detected. That being said, Davis outputs all alerting timeframes in UTC, and I was wondering how I can convert those timestamps to EST or New York Time. Many of the required filters seem absent, I can only pipe to "to_datetime" to change the format, but not cast the timezone. Would I require an intermediate Javascript task to perform the timezone cast that way?</P> Thu, 05 Feb 2026 16:55:35 GMT Rudolph_Sedlin 2026-02-05T16:55:35Z https://community.dynatrace.com/t5/Automations/Davis-output-timestamps/m-p/294275#M2498 <P>Hey all.<BR /><BR />I currently have quite a few workflows that run Davis Anomaly Detection on a schedule. I then parse the Davis output and issue emails if any anomalies are detected via a "Send Emails" workflow task, using the provided filters to check for alerts and format a markdown table of all alerts detected. That being said, Davis outputs all alerting timeframes in UTC, and I was wondering how I can convert those timestamps to EST or New York Time. Many of the required filters seem absent, I can only pipe to "to_datetime" to change the format, but not cast the timezone. Would I require an intermediate Javascript task to perform the timezone cast that way?</P> Thu, 05 Feb 2026 16:55:35 GMT https://community.dynatrace.com/t5/Automations/Davis-output-timestamps/m-p/294275#M2498 Rudolph_Sedlin 2026-02-05T16:55:35Z https://community.dynatrace.com/t5/Automations/Davis-output-timestamps/m-p/294288#M2503 <P>If you are using a DQL Query to get the results you can shift the time directly in the query before it ever reaches the email task using the formatTimestamp function with an offset.</P><LI-CODE lang="markup">| fieldsAdd startTimeEST = formatTimestamp(startTime, format:"yyyy-MM-dd HH:mm:ss", timezone:"America/New York")</LI-CODE><P>Using JS is a better way, but maybe this is quickier.</P><P>Hope it does the trick&nbsp;<a href="https://community.dynatrace.com/t5/user/viewprofilepage/user-id/99459">@Rudolph_Sedlin</a>&nbsp;</P> Thu, 05 Feb 2026 20:48:44 GMT https://community.dynatrace.com/t5/Automations/Davis-output-timestamps/m-p/294288#M2503 DanielS 2026-02-05T20:48:44Z