Supported Date Formats

Important: Tableau Web Data Connector 2.0 (this version) is being deprecated at Tableau 2023.1 and eventually retired. We will still support WDC 2.0 until its last compatible version of Tableau (Tableau 2022.4) goes End of Life and is no longer supported.

For information about Tableau Web Data Connector 3.0, see the WDC 3.0 documentation.

Edit this page Submit an issue

Web data connectors can work with Date and DateTime values that use the following formats:

dd-MM-yyyy
dd-MMM
dd-MMM-yy
dd-MMM-yyyy
dd-MMM-yyyy HH:mm:ss
dd/MM/yyyy
h:mm a
HH.mm
hh.mm a
HH.mm.ss
hh.mm.ss a
hh:mm a
HH:mm:ss
hh:mma
M/d/yyyy HH:mm:ss
MM-dd-yyyy
MM-dd-yyyy HH:mm
MM/dd/yy
MM/dd/yy HH:mm:ss
MM/dd/yyyy
MM/dd/yyyy
MM/dd/yyyy HH:mm:ss
MM/dd/yyyy hh:mm:ss a
MMM yyyy
MMM-yy
MMMM dd yyyy
MMMM dd yyyy hh:mma
MMMM dd, yyyy
MMMM dd, yyyy HH:mm:ss
MMMM dd,yyyy
MMMM dd,yyyy HH:mm:ss
yyyy-MM-dd
yyyy-MM-dd HH:mm
yyyy-MM-dd HH:mm:ss
yyyy-MM-dd HH:mm:ss.SSS
yyyy-MM-dd HH:mm:ss.SSS
yyyy-MM-dd HH:mm:ss.SSS
yyyy/MM/dd
yyyy/MM/dd HH:mm:ss

For information about the symbols used in these format examples, see Formatting Dates and Times on the ICU User Guide site.