LEARN MORE:
https://599cd.com/ISODates
CONNECTIONS:
UTC and DST: https://599cd.com/UTC
Input masks: https://599cd.com/InputMask
FOR MORE INFORMATION
https://www.iso.org/iso-8601-date-and-time-format.html
https://www.iso.org/news/2017/02/Ref2164.html
https://xkcd.com/1179/
https://en.wikipedia.org/wiki/ISO_8601
https://www.cl.cam.ac.uk/mgk25/iso-time.html
COURSE:
FREE Windows Beginner Level 1: https://599cd.com/Free1
1 Windows level 2: https://599cd.com/1Dollar
ADDITIONAL RESOURCES:
Donate to my Tip Jar: https://599cd.com/TipJar
Subscribe to my mailing list: https://599cd.com/YTML
Contact me: https://599cd.com/Contact
Tech Help: https://599cd.com/TechHelp
Consultation help: https://599cd.com/DevNet
Twitter: https://twitter.com/599cd
https://en.wikipedia.org/wiki/Microsoft_Windows
https://www.microsoft.com/en-us/windows
KEYWORDS
Windows 10, Windows 11, Microsoft Windows, MS Windows, MS Windows tutorial, #mswindows, #microsoftwindows, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, iso 8601 benefits and disadvantages, world standard date and time format, international date standard, universal date format, short date, two-digit time
QUESTIONS:
Please feel free to post your questions or comments below. THANKS.
TOPICS COVERED:
If you communicate with people in other countries, whether for business or pleasure, you need a dating standard that is the same for everyone. When you have dates displayed like 04/02/2022, that could mean April 2 or February 4, depending on where you are.
This can be embarrassing on a personal level. /"My flight will land at noon on 02/3/22./" This can be expensive at the professional level! /"To avoid late fees, your bill is due 4/5/22./"
Personally, I have students in almost every country in the world. When people ask me questions and I answer, it can be very confusing for both of us. The ISO 8601 standard date format is unambiguous. No matter where you are, the date 03/10/2022 is always October 3, 2022.
Date and time values are ordered from largest unit of time to smallest: year, month, day, hour, minute, second. Each date value has a fixed number of digits, padded with leading zeros. YYYY-MM-DD
Dates can also be written without separators. This was more common with older computers storing date values in text files. YYYYMMDD
In addition to being a logical and unambiguous date format, ISO dates are naturally sortable strings. No separate logic is required to sort them.
In Windows, open region settings, click Change data formats, select ISO short date.
The ISO time standard is (local time zone): HH:NN:SS.xx
ISO time with an added time zone: HH:NN:SS00:00
ISO time in UTC: HH:NN:SSZ
Combined ISO date/time standards:
YYYY-MM-DD HH:NN:SS
YYYY-MM-DDTHH: NN: SS
YYYY-MM-DDTHH:NN:SS00:00
YYYY-MM-DDTHH: NN: SSZ
YYYYMMDDHHNNSSZ
I will, however, change my time settings from a single digit TIME to a double digit hour. This is more in line with the ISO standard. You'll see why when we talk about Access shortly.
EXCEL USERS:
When you make this change, dates that you formatted as simply Date or Short Date will be replaced with ISO dates. Any custom date formats you have set up will not be changed.
Be careful entering new date values now. If you just type /"1/2/" you will always get January 02. But if you type /"1/2/22/" you will get 2001-02-22.
ACCESS USERS:
Likewise, any existing short date fields (which are the default) will be replaced with the new ISO date format. So unless you have custom date formats you will be fine.
Entering new date values that are a little different from those in Excel. The form field will always keep the same format, unlike Excel where the format can change depending on what you type. Assuming short dates: typing /"1/2/" you will get 02/01/2022. By typing /"1/2/22/" you will get 2001-02-22
Dates are always stored internally as a number, so you shouldn't have to worry. All functions like DateAdd, DatePart, Year, Month, Format, etc. should all work the same way. The only time you might encounter a problem is if you import data from spreadsheets or differently formatted text files. Be sure to double-check everything you import!
If you don't change the Windows Short Time setting I mentioned earlier to display double-digit times, even if you use hh:nn to display times, Access will still use the single-digit Windows Short Time format.
Use an input mask to help your users get used to entering dates with the new format. https://599cd.com/InputMask
I'm making the change myself today, so I'm sure I'll have plenty of tips, tricks and pointers in the coming weeks. Stay tuned for more! https://599cd.com/ISODates
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments