I have a report in which a date/time field is converted from GMT to MST/MDT, depending on if it is currently in Daylight Savings Time. Since DST ends/begins on a different date every year, how do automatically change which timezone to convert to in the query?
hi @matstap,
Did either of the answers below solve your problem? If so, please resolve this post by approving one of them. If not, keep us updated so that someone else can help you solve your problem.
Also, if you're feeling generous, give out an upvote to the user that helped ya. Our users love them upvotes. 🙂
Hi @matstap,
I'm not sure it's going to work out as you would like it to work out.
But I can point you to a great solution to this question from a fellow member of this community.
This answer is from @woodcock:
https://answers.splunk.com/answers/241990/does-splunk-take-into-consideration-timezone-dayli.html
I hope this helps you in your struggle!