MickyMartian232

Date/Time Formats
Last Updated: 2021-03-03
The Date Formats global option changes the default date format for all maps or forms. However, the format of the existing date fields do not change; the default is only used for new maps or forms.
This table lists the valid date and time formats.
Format Description YYMMDD Two-digit year, two-digit month, two-digit day MMDDYY Two-digit month, two-digit day, last two digits of year (example: 121599) YYYYMMDD Four-digit year, two-digit month, two-digit day (example: 19991215) DDMMYYYY Two-digit day, two-digit month, four-digit year (example: 15121999) MMDDYYYY Two-digit month, two-digit day, four-digit year (example: 12151999) DDMMYY Two-digit day, two-digit month, last two digits of year (example: 151299) YYMMMDD Last two digits of year, three-letter abbreviation of the month, two-digit day (example: 99JAN02) DDMMMYY Two-digit day, three-letter https://greecepowerballresults.co.za/abbreviation of the month, last two digits of year (example: 02JAN99) MMMDDYY Three-letter abbreviation of the month, two-digit day, last two digits of year (example: JAN0299) YYYYMMMDD Four-digit year, three-letter abbreviation of the month, two-digit day (example: 2003JUL04) DDMMMYYYY Two-digit day, three-letter abbreviation of the month, four-digit year (example: 04JUL2003) MMMDDYYYY Three-letter abbreviation of the month, two-digit day, four-digit year (example: JUL042003) YYDDD Last two digits of year, three-digit Julian day (example: 99349 for the 349th day of 1999) DDDYY Three-digit Julian day, last two digits of year (example: 34999) YYYYDDD Four-digit year, three-digit Julian day (example: 1999349) DDDYYYY Three-digit Julian day, four-digit year (example: 3491999) YY/MM/DD Last two digits of year, separator, two-digit month, separator, twodigit day (example: 99/12/05) DD/MM/YY Two-digit day, separator, two-digit month, separator, last two digits of year (example: 05/12/99) MM/DD/YY Two-digit month, separator, two-digit day, separator, last two digits of year (example: 12/15/99) YYYY/MM/DD Four-digit year, separator, two-digit month, separator, two-digit day (example: 1999/12/15) DD/MM/YYYY Two-digit day, separator, two-digit month, separator, four-digit year (example: 15/12/1999) MM/DD/YYYY Two-digit month, separator, two-digit day, separator, four-digit year (example: 12/15/1999) YY/MMM/DD YY/MMM/DD Two-digit year, separator, three-letter abbreviation of the month, separator, two-digit day (example: 99/JUL/20) DD/MMM/YY Two-digit day, separator, three-letter abbreviation of the month, separator, two-digit year (example: 20/JUL/99) MMM/DD/YY Three-letter abbreviation of the month, separator, two-digit day, separator, two-digit year (example: JUL/20/99) YYYY/MMM/DD Four-digit year, separator, three-letter abbreviation of the month, separator, two-digit day (example: 2003/JUL/25) DD/MMM/YYYY Two-digit day, separator, three-letter abbreviation of the month, separator, four-digit year (example: 25/JUL/2003) MMM/DD/YYYY Three-letter abbreviation of the month, separator, two-digit day, separator, four-digit year (example: JUL/25/2003) YY/DDD Last two digits of year, separator, three-digit Julian day (example: 99/349) DDD/YY Three-digit Julian day, separator, last two digits of year (example: 349/99) YYYY/DDD Four-digit year, separator, three-digit Julian day (example: 1999/ 349) DDD/YYYY Three-digit Julian day, separator, four-digit year (example: 349/ 1999) MONTH Month (example: December) DAY Day of the week (example: Friday) HHMM Two-digit hour, two-digit minutes (example: 0330 for 30 minutes past 3 o'clock) HHMMSS Two-digit hour, two-digit minutes, two-digit seconds (example: 033045 for 30 minutes and 45 seconds past 3 o’clock) HH:MM Two-digit hour, separator, two-digit minutes (example: 03:30) HH:MM:SS Two-digit hour, separator, two-digit minutes, separator, two-digit seconds (example: 03:30:45) YYYYMMDDTHH MMSS.mmmZ ISO-8601 format: Four-digit year, two-digit month, two-digit day, T (time) indicator, two-digit hour, two-digit minutes, two-digit seconds in Universal Time (also called Zulu Time or Greenwich Mean Time), Z (Zulu time) indicator (example: 20031209T123000.000Z) YYYYMMDDZ ISO-8601 date format: Four-digit year, two-digit month, two-digit day, Z (Zulu time) indicator (example: 20031209Z) MM/DD/YY HH:MM:SS Two-digit month, separator, two-digit day, separator, last two digits of year, two-digit hour, separator, two-digit minutes, separator, two-digit seconds (example: 12/15/99 03:30:45) YYMMDD HHMMSS Last two digits of year, two-digit month, two-digit day, two-digit hour, two-digit minutes, two-digit seconds (example: 991025 033045) YYYY-MMDDTHH: MM:SS Four-digit year, separator, two-digit month, separator, two-digit day, T represents a blank separator, two-digit hour, separator, twodigit minutes, separator, two-digit seconds (example: 2002-02-02 03:30:45) YYYY-MM-DD Four-digit year, separator, two-digit month, separator, two-digit day (example: 2002-02-02) YYYY-MM Four-digit year, separator, two-digit month (example: 2002-02) YYYY Four-digit year (example: 2002) --MM-DD Two dashes, two-digit month, separator, two-digit day (example: - -12-02) ---DD Three dashes, two-digit day (example: ---02)

Date/Time Formats
Last Updated: 2021-03-03
The Date Formats global option changes the default date format for all maps or forms. However, the format of the existing date fields do not change; the default is only used for new maps or forms.
This table lists the valid date and time formats.
Format Description YYMMDD Two-digit year, two-digit month, two-digit day MMDDYY Two-digit month, two-digit day, last two digits of year (example: 121599) YYYYMMDD Four-digit year, two-digit month, two-digit day (example: 19991215) DDMMYYYY Two-digit day, two-digit month, four-digit year (example: 15121999) MMDDYYYY Two-digit month, two-digit day, four-digit year (example: 12151999) DDMMYY Two-digit day, two-digit month, last two digits of year (example: 151299) YYMMMDD Last two digits of year, three-letter abbreviation of the month, two-digit day (example: 99JAN02) DDMMMYY Two-digit day, three-letter https://greecepowerballresults.co.za/abbreviation of the month, last two digits of year (example: 02JAN99) MMMDDYY Three-letter abbreviation of the month, two-digit day, last two digits of year (example: JAN0299) YYYYMMMDD Four-digit year, three-letter abbreviation of the month, two-digit day (example: 2003JUL04) DDMMMYYYY Two-digit day, three-letter abbreviation of the month, four-digit year (example: 04JUL2003) MMMDDYYYY Three-letter abbreviation of the month, two-digit day, four-digit year (example: JUL042003) YYDDD Last two digits of year, three-digit Julian day (example: 99349 for the 349th day of 1999) DDDYY Three-digit Julian day, last two digits of year (example: 34999) YYYYDDD Four-digit year, three-digit Julian day (example: 1999349) DDDYYYY Three-digit Julian day, four-digit year (example: 3491999) YY/MM/DD Last two digits of year, separator, two-digit month, separator, twodigit day (example: 99/12/05) DD/MM/YY Two-digit day, separator, two-digit month, separator, last two digits of year (example: 05/12/99) MM/DD/YY Two-digit month, separator, two-digit day, separator, last two digits of year (example: 12/15/99) YYYY/MM/DD Four-digit year, separator, two-digit month, separator, two-digit day (example: 1999/12/15) DD/MM/YYYY Two-digit day, separator, two-digit month, separator, four-digit year (example: 15/12/1999) MM/DD/YYYY Two-digit month, separator, two-digit day, separator, four-digit year (example: 12/15/1999) YY/MMM/DD YY/MMM/DD Two-digit year, separator, three-letter abbreviation of the month, separator, two-digit day (example: 99/JUL/20) DD/MMM/YY Two-digit day, separator, three-letter abbreviation of the month, separator, two-digit year (example: 20/JUL/99) MMM/DD/YY Three-letter abbreviation of the month, separator, two-digit day, separator, two-digit year (example: JUL/20/99) YYYY/MMM/DD Four-digit year, separator, three-letter abbreviation of the month, separator, two-digit day (example: 2003/JUL/25) DD/MMM/YYYY Two-digit day, separator, three-letter abbreviation of the month, separator, four-digit year (example: 25/JUL/2003) MMM/DD/YYYY Three-letter abbreviation of the month, separator, two-digit day, separator, four-digit year (example: JUL/25/2003) YY/DDD Last two digits of year, separator, three-digit Julian day (example: 99/349) DDD/YY Three-digit Julian day, separator, last two digits of year (example: 349/99) YYYY/DDD Four-digit year, separator, three-digit Julian day (example: 1999/ 349) DDD/YYYY Three-digit Julian day, separator, four-digit year (example: 349/ 1999) MONTH Month (example: December) DAY Day of the week (example: Friday) HHMM Two-digit hour, two-digit minutes (example: 0330 for 30 minutes past 3 o'clock) HHMMSS Two-digit hour, two-digit minutes, two-digit seconds (example: 033045 for 30 minutes and 45 seconds past 3 o’clock) HH:MM Two-digit hour, separator, two-digit minutes (example: 03:30) HH:MM:SS Two-digit hour, separator, two-digit minutes, separator, two-digit seconds (example: 03:30:45) YYYYMMDDTHH MMSS.mmmZ ISO-8601 format: Four-digit year, two-digit month, two-digit day, T (time) indicator, two-digit hour, two-digit minutes, two-digit seconds in Universal Time (also called Zulu Time or Greenwich Mean Time), Z (Zulu time) indicator (example: 20031209T123000.000Z) YYYYMMDDZ ISO-8601 date format: Four-digit year, two-digit month, two-digit day, Z (Zulu time) indicator (example: 20031209Z) MM/DD/YY HH:MM:SS Two-digit month, separator, two-digit day, separator, last two digits of year, two-digit hour, separator, two-digit minutes, separator, two-digit seconds (example: 12/15/99 03:30:45) YYMMDD HHMMSS Last two digits of year, two-digit month, two-digit day, two-digit hour, two-digit minutes, two-digit seconds (example: 991025 033045) YYYY-MMDDTHH: MM:SS Four-digit year, separator, two-digit month, separator, two-digit day, T represents a blank separator, two-digit hour, separator, twodigit minutes, separator, two-digit seconds (example: 2002-02-02 03:30:45) YYYY-MM-DD Four-digit year, separator, two-digit month, separator, two-digit day (example: 2002-02-02) YYYY-MM Four-digit year, separator, two-digit month (example: 2002-02) YYYY Four-digit year (example: 2002) --MM-DD Two dashes, two-digit month, separator, two-digit day (example: - -12-02) ---DD Three dashes, two-digit day (example: ---02)