Davis output timestamps

[Rudolph_Sedlin]

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?

[DanielS · Accepted solution]

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.

| 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 @Rudolph_Sedlin