Convert GMT Dataset Column TO Local time (GMT - 4)

Get Help CMS Features and Functionality
1

Hello,
I have a dataset that stores football Date Time in GMT.

image
image1644×616 33.7 KB

I was able to create a Formula Column (KOT) to format the date into something more human-friendly.
$dateFormat(Date,l jS F - g:iA)

image
image1148×921 33.7 KB

Now I’m stuck with figuring how to create a new column to convert this GMT time to localtime. Either of these 2 ways would work for me

  1. Date Time Conversion (GMT -4) in a Formula Column OR
  2. Date time conversion in the Dataset Ticker itself (and local time displated on any client it’s scheduled on :grinning:).

Any idea if it’s possible to get any of these done?

2

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.