Supported Date Formats

🕐 1 min read

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.