We have special field in z-data BizType = UTC to show UTC dates in services.
I wonder if it can be used in BAQ…
In that case you would not need to use this formula, which does not work for DST change apparently.
1 Like
OK, you have me curious - what is that? It sounds like one of those tables that start with Z.
OK, I see it. it’s ZDataField.
But yeah nothing leaps off the page.
z-data are dictionary describing data.
To specify the same attribute in flag, you can use Attributes form, it is in Display fields.
There you select the field and set the same attribute BizType=UTC
The problem is the it does not work for me in BAQ Designer in browser, but it works in smart client. You can check what happens in dashboard, This is either Kinetic BAQ designer bug, or browser client bug.
1 Like
Whoa.
I will try this…
I don’t think I can change it.
When I pull in SysTask.StartedOn, it is already UTC.
If I try to clear it out, it refuses:
And the only values that exist in the ZDataField table for datetime fields are either UTC or [empty sting]. (I checked for anything not equal to UTC and they are all blanks.)
Maybe try to create calc field that contains just StartedOn field.
1 Like
I’m not having any luck.
My BAQ has the StartedOn field in 3 ways:
- Raw
- Calculated but nothing fancy
- Calculated but adding the
BizType = UTCattribute.
And then this is a dashboard (preview) in App Studio.
It’s all good. I greatly appreciate you working on this with me.
Well, this is clearly a bug, so you should report it.
In smart client at least calc field with UTC biztype attribute works as expected.
I did not check dashboard.
as a workaround you can try another sql function
If you need only one timezone.
Something like
CONVERT(datetime, StartedOn AT TIME ZONE 'UTC' AT TIME ZONE 'Eastern Standard Time')
2 Likes
Mine updated last DST but not this one. 
3 Likes
Spring forward, fall flat on our face. Welcome to IT.
1 Like