• Cloud
  • 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