Syntax for datetime conversions from UTC
Hey everyone.
I'm attempting to convert a date from UTC to my locale, and for some reason I can't seem to get the Ensemble ConvertDateTime Utility Function to detect the timezone to then convert. I'm hoping it's just a syntax issue, and that someone can show me the error of my ways.
The date format is YYYYMMDDHHmmss+0000 (so for example, 20210401102030+0000)
I was expecting that setting the informat to "%q%z" would mean that the %z picks up the +0000 as UTC, but it doesn't seem to make a difference. The only way I've been able to make this work is by using %K(0) at the start of the informat to explicitly state that it is UTC, but I feel that it's an easy way out.
Any pointers are greatly appreciated.
Have you tried %K(Server) as the output format prefix?
This of course assumes your server is in your locale/time zone.Hey Jeffrey.
That's done the trick - I wrongly assumed that not specifying the locale in the outformat would assume the current locale.
Thank you for your help!