You are here: Field Types > DateTime > Date Formatting Conventions

Date Formatting Conventions

There are many date formatting conventions in use. The most common are shown in the table below.

Common Date Format

 

Type

 

Example Using December 31, 1999

 

YYYY-MM-DD

ISO

1999-12-31

DD/MM/YY, DD.MM.YY or DD-MM-YY

European

31/12/99

MM/DD/YY

American

12/31/99

YYDDD

Julian

99365