function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

How to convert timezone for datetime field based for all records based on state timezone in einstein dataflow

Hi Everyone,

I have a complex requirement, for which I need a dashboard to show all records in their respective state timestamps
Has anyone implemented Timezone conversion in Einstein Analytics Dataflows
I have a requirement where the pulled data from salesforce native object is showing timezone of integration user
Based on the service resource/user state I need to change the timezone in einstein and show date/timestamp fields of service appointments in state timezone
This is currently maintained in Excel sheets
I want to know is there a way I can get Canada USA state zip code timezone dataset which will show difference/offset. Any web links from where I can download these datasets.
Then this offset/time difference value, I can use for computation of timestamp fields which will give correct data always.
Also, I was thinking is there any API that I should explore to always have this timezone information up to date considering the daylight saving in some countries.