Skip to main content
Version: 8.1


This function is used in Python Scripting.


Returns a new dataset replacing date typed columns with string typed columns. The new columns will match the formatting specified by the dateFormat parameter.

Client Permission Restrictions​

This scripting function has no Client Permission restrictions.


system.dataset.formatDates( dataset, dateFormat, [locale] )


Dataset / PyDatasetdatasetThe starting dataset to format.
StringdateFormatA valid Java DateFormat string, representing how the date should be formatted. For example: "yyyy-MM-dd HH:mm:ss". Refer to Data Type Formatting Reference for more information on the valid characters.
LocalelocaleThe Locale to use for formatting. The Locale parameter accepts any valid Java Locale object, which can be found here. The Java Locale class must be imported, and the Locale must be defined in all caps. See the second example below for an idea of how that works. If no locale is provided, the system’s locale will be used. [optional]


Dataset - A new dataset, containing the formatted dates.


Gateway, Vision Client, Perspective Session

Code Examples​

Code Snippet
# This example takes the dataset from a Vision Table component and formats the dates to look like Fri, Jan 22, 2018.
# Reference the table's existing dataset
data = event.source.parent.getComponent('Table').data

# Apply formatting, and store the results in a new variable
formattedData = system.dataset.formatDates(data, "EEE, MMM d, yyyy")

# Write back to the table
event.source.parent.getComponent('Table').data = formattedData
Code Snippet
# This example formats the date similarly to the last example, but uses the Italian Locale, which causes the dates to be formatted with the Locale.

from java.util import Locale

data = event.source.parent.getComponent('Table').data
locale = Locale.ITALY
formattedDataFr = system.dataset.formatDates(data, "yyyy-MM-dd HH:mm:ss", locale)

# Write back to the table
event.source.parent.getComponent('Table').data = formattedDataFr


system dataset formatDates, dataset.formatDates