Date/Time field format
Date/Time Format | Explanation | Example |
---|---|---|
dd/MMM/yy | Day/Month(Three-letter abbreviation)/Year | 07/Feb/24 |
dd.MM.yy | Day.Month.Year | 07.02.24 |
dd.MM.yyyy | Day.Month.Year | 07.02.2024 |
dd/MM/yy | Day/Month/Year | 07/02/24 |
MM-dd-yyyy | Month-Day-Year | 02-07-2024 |
MMMM dd, yy | Full Month Name Day, Year | February 07, 24 |
MMM dd, yy | Month(Three-letter abbreviation), Year | Feb 07, 24 |
yyyy-MM-dd | Year-Month-Day | 2024-02-07 |
yyyy-MM-dd HH:mm | Year-Month-Day Hour:Minute in 24-hour format | 2024-02-07 15:34 |
yyyy-MM-dd hh:mm aa | Year-Month-Day Hour:Minute with AM/PM indicator | 2024-02-07 3:34 PM |
MM-dd-yyyy HH:mm | Month-Day-Year Hour:Minute in 24-hour format | 02-07-2024 15:34 |
MM-dd-yyyy hh:mm aa | Month-Day-Year Hour:Minute with AM/PM indicator | 02-07-2024 3:34 PM |
MMMM dd,yy HH:mm | Full Month Name Day, Year Hour:Minute in 24-hour format | February 07,24 15:34 |
MMMM dd, yy hh:mm aa | Full Month Name Day, Year Hour:Minute with AM/PM indicator | February 07, 24 3:34 PM |
MMM dd, yy HH:mm | Month(Three-letter abbreviation), Year Hour:Minute in 24-hour format | Feb 07, 24 15:34 |
MMM dd, yy hh:mm aa | Abbreviated Month Name Day, Year Hour:Minute with AM/PM indicator | Feb 07, 24 3:34 PM |
dd.MM.yy - HH:mm | Day.Month.Year - Hour:Minute in 24-hour format | 07.02.24 - 15:34 |
dd.MM.yy - hh:mm aa | Day.Month.Year - Hour:Minute with AM/PM indicator | 07.02.24 - 3:34 PM |
dd/MM/yy - HH:mm | Day/Month/Year - Hour:Minute in 24-hour format | 07/02/24 - 15:34 |
dd/MM/yy - hh:mm aa | Day/Month/Year - Hour:Minute with AM/PM indicator | 07/02/24 - 3:34 PM |
dd/MMM/yy H:mm | Day/Month(Three-letter abbreviation)/Year Hour:Minute in 24-hour format | 07/Feb/24 15:34 |
dd/MMM/yy h:mm aa | Day/Month(Three-letter abbreviation)/Year Hour:Minute with AM/PM indicator | 07/Feb/24 3:34 PM |