Date / Time field format


time format.png

Date/Time Format

Explanation

Example

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