User Import DateTime Format Options

From Hornbill
Jump to navigation Jump to search

Below is the list of Date, Time and DateTime Formats recognised within Hornbill:

Date Time Format List
Date Format Example
dd MM yyyy 21 02 2020
dd-MM-yyyy 21-02-2020
dd/MM/yyyy 21/02/2020
dd MM yy 21 02 20
dd-MM-yy 21-02-20
dd/MM/yy 21/02/20
yyyy MM dd 2020 02 21
yyyy-MM-dd 2020-02-21
yyyy/MM/dd 2020/02/21
yy MM dd 20 02 21
yy-MM-dd 20-02-21
yy/MM/dd 20/02/21
dd MMM yyyy 21 Feb 2020
dd-MMM-yyyy 21-Feb-2020
dd MMM yy 21 Feb 20
dd-MMM-yy 21-Feb-20
yyyy MMM dd 2020 Feb 21
yyyy-MMM-dd 2020-Feb-21
yy MMM dd 20 Feb 21
yy-MMM-dd 20-Feb-21
MM dd yyyy 02 21 2020
MM-dd-yyyy 02-21-2020
MM-dd-yy 02-21-20
MM dd yy 02 21 20
MMM dd yyyy Feb 21 2020
MMM-dd-yyyy Feb-21-2020
MMM-dd-yy Feb-21-20
MMM dd yy Feb 21 20
Time Format Example
HH:mm 23:30
HH:mm:ss 23:30:25
h:mm tt 11:30 PM
h:mm:ss tt 11:30:25 PM
DateTime Format Example
dd MM yyyy HH:mm 21 02 2020 16:10
dd MM yyyy HH:mm:ss 21 02 2020 16:10:30
dd-MM-yyyy HH:mm 21-02-2020 16:10
dd-MM-yyyy HH:mm:ss 21-02-2020 16:10:30
dd/MM/yyyy HH:mm 21/02/2020 16:10
dd/MM/yyyy HH:mm:ss 21/02/2020 16:10:30
dd MM yy HH:mm 21 02 20 16:10
dd MM yy HH:mm:ss 21 02 20 16:10:30
dd-MM-yy HH:mm 21-02-20 16:10
dd-MM-yy HH:mm:ss 21-02-20 16:10:30
dd/MM/yy HH:mm 21/02/20 16:10
dd/MM/yy HH:mm:ss 21/02/20 16:10:30
dd MM yyyy h:mm tt 21 02 2020 4:10 PM
dd MM yyyy h:mm:ss tt 21 02 2020 4:10:30 PM
dd-MM-yyyy h:mm tt 21-02-2020 4:10:30 PM
dd-MM-yyyy h:mm:ss tt 21-02-2020 4:10:30 PM
dd/MM/yyyy h:mm tt 21/02/2020 4:10:30 PM
dd/MM/yyyy h:mm:ss tt 21/02/2020 4:10:30 PM
dd MM yy h:mm tt 21 02 20 4:10 PM
dd MM yy h:mm:ss tt 21 02 20 4:10:30 PM
dd-MM-yy h:mm tt 21-02-20 4:10:30 PM
dd-MM-yy h:mm:ss tt 21-02-20 4:10:30 PM
dd/MM/yy h:mm tt 21/02/20 4:10:30 PM
dd/MM/yy h:mm:ss tt 21/02/20 4:10:30 PM
HH:mm dd MM yyyy 16:10 21 02 2020
HH:mm:ss dd MM yyyy 16:10:30 21 02 2020
HH:mm dd-MM-yyyy 16:10 21-02-2020
HH:mm:ss dd-MM-yyyy 16:10:30 21-02-2020
HH:mm dd/MM/yyyy 16:10 21/02/2020
HH:mm:ss dd/MM/yyyy 16:10:30 21/02/2020
HH:mm dd MM yy 16:10 21 02 20
HH:mm:ss dd MM yy 16:10:30 21 02 20
HH:mm dd-MM-yy 16:10 21-02-20
HH:mm:ss dd-MM-yy 16:10:30 21-02-20
HH:mm dd/MM/yy 16:10 21/02/20
HH:mm:ss dd/MM/yy 16:10:30 21/02/20
h:mm tt dd MM yyyy 4:10 PM 21 02 2020
h:mm:ss tt dd MM yyyy 4:10:30 PM 21 02 2020
h:mm tt dd-MM-yyyy 4:10:30 PM 21-02-2020
h:mm:ss tt dd-MM-yyyy 4:10:30 PM 21-02-2020
h:mm tt dd/MM/yyyy 4:10:30 PM 21/02/2020
h:mm:ss tt dd/MM/yyyy 4:10:30 PM 21/02/2020
h:mm tt dd MM yy 4:10 PM 21 02 20
h:mm:ss tt dd MM yy 4:10:30 PM 21 02 20
h:mm tt dd-MM-yy 4:10:30 PM 21-02-20
h:mm:ss tt dd-MM-yy 4:10:30 PM 21-02-20
h:mm tt dd/MM/yy 4:10:30 PM 21/02/20
h:mm:ss tt dd/MM/yy 4:10:30 PM 21/02/20
yyyy MM dd HH:mm 2020 02 21 16:10
yyyy MM dd HH:mm:ss 2020 02 21 16:10:30
yyyy-MM-dd HH:mm 2020-02-21 16:10
yyyy-MM-dd HH:mm:ss 2020-02-21 16:10:30
yyyy/MM/dd HH:mm 2020/02/21 16:10
yyyy/MM/dd HH:mm:ss 2020/02/21 16:10:30
yy MM dd HH:mm 20 02 21 16:10
yy MM dd HH:mm:ss 20 02 21 16:10:30
yy-MM-dd HH:mm 20-02-21 16:10
yy-MM-dd HH:mm:ss 20-02-21 16:10:30
yy/MM/dd HH:mm 20/02/21 16:10
yy/MM/dd HH:mm:ss 20/02/21 16:10:30
yyyy MM dd h:mm tt 2020 02 21 4:10 PM
yyyy MM dd h:mm:ss tt 2020 02 21 4:10:30 PM
yyyy-MM-dd h:mm tt 2020-02-21 4:10:30 PM
yyyy-MM-dd h:mm:ss tt 2020-02-21 4:10:30 PM
yyyy/MM/dd h:mm tt 2020/02/21 4:10:30 PM
yyyy/MM/dd h:mm:ss tt 2020/02/21 4:10:30 PM
yy MM dd h:mm tt 20 02 21 4:10 PM
yy MM dd h:mm:ss tt 20 02 21 4:10:30 PM
yy-MM-dd h:mm tt 20-02-21 4:10:30 PM
yy-MM-dd h:mm:ss tt 20-02-21 4:10:30 PM
yy/MM/dd h:mm tt 20/02/21 4:10:30 PM
yy/MM/dd h:mm:ss tt 20/02/21 4:10:30 PM
HH:mm yyyy MM dd 16:10 2020 02 21
HH:mm:ss yyyy MM dd 16:10:30 2020 02 21
HH:mm yyyy-MM-dd 16:10 2020-02-21
HH:mm:ss yyyy-MM-dd 16:10:30 2020-02-21
HH:mm yyyy/MM/dd 16:10 2020/02/21
HH:mm:ss yyyy/MM/dd 16:10:30 2020/02/21
HH:mm yy MM dd 16:10 20 02 21
HH:mm:ss yy MM dd 16:10:30 20 02 21
HH:mm yy-MM-dd 16:10 20-02-21
HH:mm:ss yy-MM-dd 16:10:30 20-02-21
HH:mm yy/MM/dd 16:10 20/02/21
HH:mm:ss yy/MM/dd 16:10:30 20/02/21
h:mm tt yyyy MM dd 4:10 PM 2020 02 21
h:mm:ss tt yyyy MM dd 4:10:30 PM 2020 02 21
h:mm tt yyyy-MM-dd 4:10:30 PM 2020-02-21
h:mm:ss tt yyyy-MM-dd 4:10:30 PM 2020-02-21
h:mm tt yyyy/MM/dd 4:10:30 PM 2020/02/21
h:mm:ss tt yyyy/MM/dd 4:10:30 PM 2020/02/21
h:mm tt yy MM dd 4:10 PM 20 02 21
h:mm:ss tt yy MM dd 4:10:30 PM 20 02 21
h:mm tt yy-MM-dd 4:10:30 PM 20-02-21
h:mm:ss tt yy-MM-dd 4:10:30 PM 20-02-21
h:mm tt yy/MM/dd 4:10:30 PM 20/02/21
h:mm:ss tt yy/MM/dd 4:10:30 PM 20/02/21
dd MMM yyyy HH:mm 21 Feb 2020 16:10
dd MMM yyyy HH:mm:ss 21 Feb 2020 16:10:30
dd-MMM-yyyy HH:mm 21-Feb-2020 16:10
dd-MMM-yyyy HH:mm:ss 21-Feb-2020 16:10:30
dd MMM yy HH:mm 21 Feb 20 16:10
dd MMM yy HH:mm:ss 21 Feb 20 16:10:30
dd-MMM-yy HH:mm 21-Feb-20 16:10
dd-MMM-yy HH:mm:ss 21-Feb-20 16:10:30
dd MMM yyyy h:mm tt 21 Feb 2020 4:10 PM
dd MMM yyyy h:mm:ss tt 21 Feb 2020 4:10:30 PM
dd-MMM-yyyy h:mm tt 21-Feb-2020 4:10:30 PM
dd-MMM-yyyy h:mm:ss tt 21-Feb-2020 4:10:30 PM
dd MMM yy h:mm tt 21 Feb 20 4:10 PM
dd MMM yy h:mm:ss tt 21 Feb 20 4:10:30 PM
dd-MMM-yy h:mm tt 21-Feb-20 4:10:30 PM
dd-MMM-yy h:mm:ss tt 21-Feb-20 4:10:30 PM
HH:mm dd MMM yyyy 16:10 21 Feb 2020
HH:mm:ss dd MMM yyyy 16:10:30 21 Feb 2020
HH:mm dd-MMM-yyyy 16:10 21-Feb-2020
HH:mm:ss dd-MMM-yyyy 16:10:30 21-Feb-2020
HH:mm dd MMM yy 16:10 21 Feb 20
HH:mm:ss dd MMM yy 16:10:30 21 Feb 20
HH:mm dd-MMM-yy 16:10 21-Feb-20
HH:mm:ss dd-MMM-yy 16:10:30 21-Feb-20
h:mm tt dd MMM yyyy 4:10 PM 21 Feb 2020
h:mm:ss tt dd MMM yyyy 4:10:30 PM 21 Feb 2020
h:mm tt dd-MMM-yyyy 4:10:30 PM 21-Feb-2020
h:mm:ss tt dd-MMM-yyyy 4:10:30 PM 21-Feb-2020
h:mm tt dd MMM yy 4:10 PM 21 Feb 20
h:mm:ss tt dd MMM yy 4:10:30 PM 21 Feb 20
h:mm tt dd-MMM-yy 4:10:30 PM 21-Feb-20
h:mm:ss tt dd-MMM-yy 4:10:30 PM 21-Feb-20
yyyy MMM dd HH:mm 2020 Feb 21 16:10
yyyy MMM dd HH:mm:ss 2020 Feb 21 16:10:30
yyyy-MMM-dd HH:mm 2020-Feb-21 16:10
yyyy-MMM-dd HH:mm:ss 2020-Feb-21 16:10:30
yy MMM dd HH:mm 20 Feb 21 16:10
yy MMM dd HH:mm:ss 20 Feb 21 16:10:30
yy-MMM-dd HH:mm 20-Feb-21 16:10
yy-MMM-dd HH:mm:ss 20-Feb-21 16:10:30
yyyy MMM dd h:mm tt 2020 Feb 21 4:10 PM
yyyy MMM dd h:mm:ss tt 2020 Feb 21 4:10:30 PM
yyyy-MMM-dd h:mm tt 2020-Feb-21 4:10:30 PM
yyyy-MMM-dd h:mm:ss tt 2020-Feb-21 4:10:30 PM
yy MMM dd h:mm tt 20 Feb 21 4:10 PM
yy MMM dd h:mm:ss tt 20 Feb 21 4:10:30 PM
yy-MMM-dd h:mm tt 20-Feb-21 4:10:30 PM
yy-MMM-dd h:mm:ss tt 20-Feb-21 4:10:30 PM
HH:mm yyyy MMM dd 16:10 2020 Feb 21
HH:mm:ss yyyy MMM dd 16:10:30 2020 Feb 21
HH:mm yyyy-MMM-dd 16:10 2020-Feb-21
HH:mm:ss yyyy-MMM-dd 16:10:30 2020-Feb-21
HH:mm yy MMM dd 16:10 20 Feb 21
HH:mm:ss yy MMM dd 16:10:30 20 Feb 21
HH:mm yy-MMM-dd 16:10 20-Feb-21
HH:mm:ss yy-MMM-dd 16:10:30 20-Feb-21
h:mm tt yyyy MMM dd 4:10 PM 2020 Feb 21
h:mm:ss tt yyyy MMM dd 4:10:30 PM 2020 Feb 21
h:mm tt yyyy-MMM-dd 4:10:30 PM 2020-Feb-21
h:mm:ss tt yyyy-MMM-dd 4:10:30 PM 2020-Feb-21
h:mm tt yy MMM dd 4:10 PM 20 Feb 21
h:mm:ss tt yy MMM dd 4:10:30 PM 20 Feb 21
h:mm tt yy-MMM-dd 4:10:30 PM 20-Feb-21
h:mm:ss tt yy-MMM-dd 4:10:30 PM 20-Feb-21
MM dd yyyy h:mm tt 02 21 2020 4:10 PM
MM dd yyyy h:mm:ss tt 02 21 2020 4:10:30 PM
MM-dd-yyyy h:mm tt 02-21-2020 4:10 PM
MM-dd-yyyy h:mm:ss tt 02-21-2020 4:10:30 PM
MM-dd-yy h:mm tt 02-21-20 4:10 PM
MM-dd-yy h:mm:ss tt 02-21-20 4:10:30 PM
MM dd yy h:mm tt 02 21 20 4:10 PM
MM dd yy h:mm:ss tt 02 21 20 4:10:30 PM
MMM dd yyyy h:mm tt Feb 21 2020 4:10 PM
MMM dd yyyy h:mm:ss tt Feb 21 2020 4:10:30 PM
MMM-dd-yyyy h:mm tt Feb-21-2020 4:10 PM
MMM-dd-yyyy h:mm:ss tt Feb-21-2020 4:10:30 PM
MMM-dd-yy h:mm tt Feb-21-20 4:10 PM
MMM-dd-yy h:mm:ss tt Feb-21-20 4:10:30 PM
MMM dd yy h:mm tt Feb 21 20 4:10 PM
MMM dd yy h:mm:ss tt Feb 21 20 4:10:30 PM
Retrieved from "https://wiki.hornbill.com/index.php?title=User_Import_DateTime_Format_Options&oldid=25464"