Does Anyone have a 'magical' report expression that converts the fields RGDT and RGTM which is UTC time?, to CST Date and Time?
Thank you in advance
I tend to do this in Prepare versus the report, but for fields that are time sensitive, especially when the the UTC conversion might push them over midnight,
DateAdd(Hour,-6,[RecordDate]) Where the [RecordDate] is a datetime field. This should also work as a BQL expression in a report.
-6 hours is the conversion from UTC to CST. you would use a different value for that time zone.
Kirk
Thank you. Unfortunately, the data is part of our pre-built M3 Analytics. I have to also worry about daylight savings time and standard time ,since not always same # of hours
Posting this document [View:/cfs-file/__key/communityserver-discussions-components-files/602/Determine-Daylight-Savings-Time.docx:44:36] which could be of some assistance.
Please be aware of performance in which case it is advisable to create two new attributes (i.e. RGDT_CT) using a Scripted Sources. Also, this becomes a custom extension to M3 Analytics.
Thank you for this Diane. What is the benefit of having a space just for the variables? Just wondering.
