Time Format in DataSets or Tables


I was wondering if there is a way to reformat time in DataSets? Here is what I am trying to do…
-I am exporting data from Daylight (Conference/Hospitality booking software) into Excel
-From there, I am saving the data as a CSV file
-I import the CSV into Xibo
-The time is exported from Daylight as military (24 hour) time format. I need 12 hour AM/PM format for my facility.

Currently, I am changing the time format in Excel before I save it as a CSV file. I was wondering if there is a way to manipulate the columns in Xibo via a formula to convert the time from 24 hour to 12 hour AM/PM.

I am also open to alternative options.

This is displays as a master list of the daily schedule on the main readerboard at our Conference/Event facility.

Perhaps create a second date column in the DataSet then use a formula to convert the first date into the format you wish in the second?

Edit: function to display dates in different formats is here: http://www.w3schools.com/sql/func_date_format.asp

1 Like