# Davis output timestamps

**URL:** <https://community.dynatrace.com/t/davis-output-timestamps/54894>\
**Category:** Automations\
**Tags:** integrations, workflows, automations\
**Created:** [February 5, 2026, 4:55pm UTC](https://community.dynatrace.com/t/davis-output-timestamps/54894 "2026-02-05T16:55:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rudolph\_Sedlin](https://avatars.discourse-cdn.com/v4/letter/r/71c47a/32.png) [@Rudolph\_Sedlin](https://community.dynatrace.com/u/Rudolph_Sedlin)\
**Post date:** [February 5, 2026, 4:55pm UTC](https://community.dynatrace.com/t/davis-output-timestamps/54894/1 "2026-02-05T16:55:35Z")

</div>

Hey all.

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?

---

<div class="post-metadata">

**Author:** ![DanielS](https://avatars.discourse-cdn.com/v4/letter/d/3ab097/32.png) [@DanielS](https://community.dynatrace.com/u/DanielS)\
**Post date:** [February 5, 2026, 8:46pm UTC](https://community.dynatrace.com/t/davis-output-timestamps/54894/2 "2026-02-05T20:46:33Z")

</div>

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.

```markup
| fieldsAdd startTimeEST = formatTimestamp(startTime, format:"yyyy-MM-dd HH:mm:ss", timezone:"America/New York")

```

Using JS is a better way, but maybe this is quickier.

Hope it does the trick&nbsp;[@Rudolph\_Sedlin](https://community.dynatrace.com/user/99459)
