Date and time formats

You can specify date and time formats used in input bulk import file. 


Date Formats

Format Example
MM/dd/yyyy11/23/2016
MM-dd-yyyy11-23-2016
MM.dd.yyyy11.23.2016
dd/MM/yyyy23/11/2016
dd-MM-yyyy23-11-2016
dd.MM.yyyy23.11.2016
yyyy/MM/dd2016/11/23
yyyy-MM-dd2016-11-23
yyyy.MM.dd2016.11.23
dd/MM/yy23/11/16
dd-MM-yy23-11-16
dd.MM.yy23.11.16
dd MMM yyyy23 Nov 2016
d MMM yyyy4 Nov 2016
dd.MMM.yyyy23.Nov.2016

Time Formats:

FormatExampleDescription
HH:mm13:30

H - Hour in a day (0-23)

m - Minutes in hour

hh:mm a1:30 PM

h - Hour in am/pm (1-12)

a - AM/PM marker

K:mm a1:30 PMK - Hour in am/pm (0-11)
k:mm13:30k - Hour in day (1-24)