-
Complete method: how to find the week-day for any date?
published: 30 Apr 2019
-
Power Query how to create and use an ISO Week Number function in Power BI
Steps to create and use a function in Power Query:
1. Define 1 or more parameters.
2. Create query.
3. Create function from query.
4. Invoke function.
Rules for ISO week number:
1. First day of the week is Monday.
2. Each week from Monday to Sunday has the same week number.
3. Week 1 of the year is the week with the first Thursday of the year,
meaning more than half of the days of the week are in week 1.
If January 1st is on Monday-Wednesday 0-2, it will be week 52 or 53 of the preceding year.
If January 1st is on Thursday-Sunday 3-6, it will be week 1 of the current year.
Steps to determine ISO week number:
1. Determine the date of Thursday of the current week.
2. Determine January 1st of the date from step 1.
3. Calculate the number of days from January 1st to the date from step 1.
4....
published: 21 Jan 2017
-
How to get ISO Week Number by using WEEKNUM function in Excel & Power Bi
published: 24 Jun 2021
-
SundaeSwap Launch Dates and How to Earn Tokens in the ISO!
Sundaeswap launch details are out. The dex will go live on Thursday Jan 20th and the ISO will go live on the 25th. I go through all the details in this video on what to expect over over the next few weeks with Sundae swap as they get their dex live on Cardano. I also talk about the sundae swap ISO and what you need to do to earn in it.
🔗 Links Mentioned 🔗
Launch Details: https://sundaeswap-finance.medium.com/wen-sundae-thursday-9389e4439530
Sundaeswap Yield Farming and Basics of Providing Liquidity!
- https://youtu.be/eCd4_LMXxFw
✅ Stay Up To Date ✅
Discord - https://www.cardanowithpaul.com/Discord
Telegram - https://www.cardanowithpaul.com/Telegram
Twitter - https://www.cardanowithpaul.com/Twitter
Website - https://www.cardanowithpaul.com/
🎯 Stake Pool Info 🎯
2 Pools under the ticker...
published: 16 Jan 2022
-
How to Switch Microsoft Access to ISO 8601 Standard Date Format to Avoid Date Confusion YYYY-MM-DD
In today's video, I'm going to show you how to switch your Windows PC to the ISO 8601 standard date format. This will help you avoid confusion when communicating with people in other countries, and prevent international incidents!
LEARN MORE:
https://599cd.com/ISODates
ADDENDUMS:
Addendum 1: https://599cd.com/ISODatesA1
LINKS:
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
COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
ADDITIONAL RESOURCES:
Donate to my Tip Jar: https:...
published: 22 Feb 2022
-
How to Switch Microsoft Windows to ISO 8601 Standard Date Format to Avoid Date Confusion YYYY-MM-DD
In today's video, I'm going to show you how to switch your Windows PC to the ISO 8601 standard date format. This will help you avoid confusion when communicating with people in other countries, and prevent international incidents!
LEARN MORE:
https://599cd.com/ISODates
LINKS:
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
COURSES:
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
Get on my Mailing List: https://...
published: 22 Feb 2022
5:37
Power Query how to create and use an ISO Week Number function in Power BI
Steps to create and use a function in Power Query:
1. Define 1 or more parameters.
2. Create query.
3. Create function from query.
4. Invoke function.
Rules f...
Steps to create and use a function in Power Query:
1. Define 1 or more parameters.
2. Create query.
3. Create function from query.
4. Invoke function.
Rules for ISO week number:
1. First day of the week is Monday.
2. Each week from Monday to Sunday has the same week number.
3. Week 1 of the year is the week with the first Thursday of the year,
meaning more than half of the days of the week are in week 1.
If January 1st is on Monday-Wednesday 0-2, it will be week 52 or 53 of the preceding year.
If January 1st is on Thursday-Sunday 3-6, it will be week 1 of the current year.
Steps to determine ISO week number:
1. Determine the date of Thursday of the current week.
2. Determine January 1st of the date from step 1.
3. Calculate the number of days from January 1st to the date from step 1.
4. Divide the number of days from step 3 by 7, round down and add 1.
https://wn.com/Power_Query_How_To_Create_And_Use_An_Iso_Week_Number_Function_In_Power_Bi
Steps to create and use a function in Power Query:
1. Define 1 or more parameters.
2. Create query.
3. Create function from query.
4. Invoke function.
Rules for ISO week number:
1. First day of the week is Monday.
2. Each week from Monday to Sunday has the same week number.
3. Week 1 of the year is the week with the first Thursday of the year,
meaning more than half of the days of the week are in week 1.
If January 1st is on Monday-Wednesday 0-2, it will be week 52 or 53 of the preceding year.
If January 1st is on Thursday-Sunday 3-6, it will be week 1 of the current year.
Steps to determine ISO week number:
1. Determine the date of Thursday of the current week.
2. Determine January 1st of the date from step 1.
3. Calculate the number of days from January 1st to the date from step 1.
4. Divide the number of days from step 3 by 7, round down and add 1.
- published: 21 Jan 2017
- views: 10848
10:14
SundaeSwap Launch Dates and How to Earn Tokens in the ISO!
Sundaeswap launch details are out. The dex will go live on Thursday Jan 20th and the ISO will go live on the 25th. I go through all the details in this video on...
Sundaeswap launch details are out. The dex will go live on Thursday Jan 20th and the ISO will go live on the 25th. I go through all the details in this video on what to expect over over the next few weeks with Sundae swap as they get their dex live on Cardano. I also talk about the sundae swap ISO and what you need to do to earn in it.
🔗 Links Mentioned 🔗
Launch Details: https://sundaeswap-finance.medium.com/wen-sundae-thursday-9389e4439530
Sundaeswap Yield Farming and Basics of Providing Liquidity!
- https://youtu.be/eCd4_LMXxFw
✅ Stay Up To Date ✅
Discord - https://www.cardanowithpaul.com/Discord
Telegram - https://www.cardanowithpaul.com/Telegram
Twitter - https://www.cardanowithpaul.com/Twitter
Website - https://www.cardanowithpaul.com/
🎯 Stake Pool Info 🎯
2 Pools under the ticker PAUL & PAUL1
Pool 1 ID: 86a19d5418cd07294af7d71386cf14a84e0478fbfde5b89fe4d98a58
Pool 2 ID: a89b86373838360143aba3911eaae54bf9420868965d48d447e4510a
All delegations very much appreciated as they help support my channels
Share this video - https://youtu.be/0KcwG-QbZVk
#Cardano #Sundaeswap #SundaeSwapDex
Disclaimer: Everything in this video is my own opinion and is not financial advise as I am not a financial advisor. I am just a random guy on the internet with a big passion for crypto
https://wn.com/Sundaeswap_Launch_Dates_And_How_To_Earn_Tokens_In_The_Iso
Sundaeswap launch details are out. The dex will go live on Thursday Jan 20th and the ISO will go live on the 25th. I go through all the details in this video on what to expect over over the next few weeks with Sundae swap as they get their dex live on Cardano. I also talk about the sundae swap ISO and what you need to do to earn in it.
🔗 Links Mentioned 🔗
Launch Details: https://sundaeswap-finance.medium.com/wen-sundae-thursday-9389e4439530
Sundaeswap Yield Farming and Basics of Providing Liquidity!
- https://youtu.be/eCd4_LMXxFw
✅ Stay Up To Date ✅
Discord - https://www.cardanowithpaul.com/Discord
Telegram - https://www.cardanowithpaul.com/Telegram
Twitter - https://www.cardanowithpaul.com/Twitter
Website - https://www.cardanowithpaul.com/
🎯 Stake Pool Info 🎯
2 Pools under the ticker PAUL & PAUL1
Pool 1 ID: 86a19d5418cd07294af7d71386cf14a84e0478fbfde5b89fe4d98a58
Pool 2 ID: a89b86373838360143aba3911eaae54bf9420868965d48d447e4510a
All delegations very much appreciated as they help support my channels
Share this video - https://youtu.be/0KcwG-QbZVk
#Cardano #Sundaeswap #SundaeSwapDex
Disclaimer: Everything in this video is my own opinion and is not financial advise as I am not a financial advisor. I am just a random guy on the internet with a big passion for crypto
- published: 16 Jan 2022
- views: 26012
16:56
How to Switch Microsoft Access to ISO 8601 Standard Date Format to Avoid Date Confusion YYYY-MM-DD
In today's video, I'm going to show you how to switch your Windows PC to the ISO 8601 standard date format. This will help you avoid confusion when communicatin...
In today's video, I'm going to show you how to switch your Windows PC to the ISO 8601 standard date format. This will help you avoid confusion when communicating with people in other countries, and prevent international incidents!
LEARN MORE:
https://599cd.com/ISODates
ADDENDUMS:
Addendum 1: https://599cd.com/ISODatesA1
LINKS:
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
COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
ADDITIONAL RESOURCES:
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/
KEYWORDS
access 2016, access 2019, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, iso 8601 advantages and disadvantages, global standard date and time format, international date standard, universal date format, short date, two digit hour
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 date standard that's the same for everyone. When you have dates displayed like 4/2/2022, that could mean April 2nd or February 4th, depending on where you're located.
This can be embarrassing on a personal level. "My flight will be landing at noon on 2/3/22." This can be costly on a business level! "To avoid a late fee, your invoice is due on 4/5/22."
I personally have students in almost every country of the world. When people ask me questions, and I reply, it can be very confusing for both of us. The ISO 8601 standard date format is unambiguous. Regardless of where you are, the date 2022-10-03 is always October 3rd, 2022.
Date and time values are ordered from largest to smallest unit of time: year, month, day, hour, minute, second. Each date value has a fixed number of digits, padded with leading zeros. YYYY-MM-DD
Dates may 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 the ISO Short Date.
The ISO Time standard is (local time zone): HH:NN:SS.xx
The ISO Time with a Time Zone added: HH:NN:SS+00:00
The ISO Time in UTC: HH:NN:SSZ
The ISO Combined Date/Time Standards:
YYYY-MM-DD HH:NN:SS
YYYY-MM-DDTHH:NN:SS+00:00
YYYY-MM-DDTHH:NN:SSZ
YYYYMMDDTHHNNSSZ
I am going to change my time settings from a single-digit HOUR to a double-digit one though. That’s more in line with the standard. You’ll see why when we talk about Access shortly.
Any existing Short Date fields (which is the default) will be changed to the new ISO Date format. So unless you have any custom date formats, you'll be fine.
Typing in new date values a little bit different than Excel. The field on the form will always keep the same format, unlike Excel where the format may change based on what you type. Assuming Short Dates: Typing "1/2" will give you 2022-01-02. Typing "1/2/22" will give you 2001-02-22
Dates are still stored internally as a number, so you shouldn't have to worry. Any functions like DateAdd, DatePart, Year, Month, Format, etc. should all still work the same. The only time you may have a problem is if you’re importing data from spreadsheets or text files that are formatted differently. Be sure to double-check anything you import!
If you don't change the Windows Short Time setting that I mentioned earlier to show two-digit hours, then even if you use hh:nn to display times, Access will still use the Windows single-digit 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 just making the change myself today, so I'm sure I'll have a lot of tips, tricks, and pointers in the coming weeks. Stay tuned for more! https://599cd.com/ISODates
https://wn.com/How_To_Switch_Microsoft_Access_To_Iso_8601_Standard_Date_Format_To_Avoid_Date_Confusion_Yyyy_Mm_Dd
In today's video, I'm going to show you how to switch your Windows PC to the ISO 8601 standard date format. This will help you avoid confusion when communicating with people in other countries, and prevent international incidents!
LEARN MORE:
https://599cd.com/ISODates
ADDENDUMS:
Addendum 1: https://599cd.com/ISODatesA1
LINKS:
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
COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
ADDITIONAL RESOURCES:
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/
KEYWORDS
access 2016, access 2019, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, iso 8601 advantages and disadvantages, global standard date and time format, international date standard, universal date format, short date, two digit hour
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 date standard that's the same for everyone. When you have dates displayed like 4/2/2022, that could mean April 2nd or February 4th, depending on where you're located.
This can be embarrassing on a personal level. "My flight will be landing at noon on 2/3/22." This can be costly on a business level! "To avoid a late fee, your invoice is due on 4/5/22."
I personally have students in almost every country of the world. When people ask me questions, and I reply, it can be very confusing for both of us. The ISO 8601 standard date format is unambiguous. Regardless of where you are, the date 2022-10-03 is always October 3rd, 2022.
Date and time values are ordered from largest to smallest unit of time: year, month, day, hour, minute, second. Each date value has a fixed number of digits, padded with leading zeros. YYYY-MM-DD
Dates may 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 the ISO Short Date.
The ISO Time standard is (local time zone): HH:NN:SS.xx
The ISO Time with a Time Zone added: HH:NN:SS+00:00
The ISO Time in UTC: HH:NN:SSZ
The ISO Combined Date/Time Standards:
YYYY-MM-DD HH:NN:SS
YYYY-MM-DDTHH:NN:SS+00:00
YYYY-MM-DDTHH:NN:SSZ
YYYYMMDDTHHNNSSZ
I am going to change my time settings from a single-digit HOUR to a double-digit one though. That’s more in line with the standard. You’ll see why when we talk about Access shortly.
Any existing Short Date fields (which is the default) will be changed to the new ISO Date format. So unless you have any custom date formats, you'll be fine.
Typing in new date values a little bit different than Excel. The field on the form will always keep the same format, unlike Excel where the format may change based on what you type. Assuming Short Dates: Typing "1/2" will give you 2022-01-02. Typing "1/2/22" will give you 2001-02-22
Dates are still stored internally as a number, so you shouldn't have to worry. Any functions like DateAdd, DatePart, Year, Month, Format, etc. should all still work the same. The only time you may have a problem is if you’re importing data from spreadsheets or text files that are formatted differently. Be sure to double-check anything you import!
If you don't change the Windows Short Time setting that I mentioned earlier to show two-digit hours, then even if you use hh:nn to display times, Access will still use the Windows single-digit 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 just making the change myself today, so I'm sure I'll have a lot of tips, tricks, and pointers in the coming weeks. Stay tuned for more! https://599cd.com/ISODates
- published: 22 Feb 2022
- views: 2217
16:18
How to Switch Microsoft Windows to ISO 8601 Standard Date Format to Avoid Date Confusion YYYY-MM-DD
In today's video, I'm going to show you how to switch your Windows PC to the ISO 8601 standard date format. This will help you avoid confusion when communicatin...
In today's video, I'm going to show you how to switch your Windows PC to the ISO 8601 standard date format. This will help you avoid confusion when communicating with people in other countries, and prevent international incidents!
LEARN MORE:
https://599cd.com/ISODates
LINKS:
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
COURSES:
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
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting 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 advantages and disadvantages, global standard date and time format, international date standard, universal date format, short date, two digit hour
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 date standard that's the same for everyone. When you have dates displayed like 4/2/2022, that could mean April 2nd or February 4th, depending on where you're located.
This can be embarrassing on a personal level. "My flight will be landing at noon on 2/3/22." This can be costly on a business level! "To avoid a late fee, your invoice is due on 4/5/22."
I personally have students in almost every country of the world. When people ask me questions, and I reply, it can be very confusing for both of us. The ISO 8601 standard date format is unambiguous. Regardless of where you are, the date 2022-10-03 is always October 3rd, 2022.
Date and time values are ordered from largest to smallest unit of time: year, month, day, hour, minute, second. Each date value has a fixed number of digits, padded with leading zeros. YYYY-MM-DD
Dates may 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 the ISO Short Date.
The ISO Time standard is (local time zone): HH:NN:SS.xx
The ISO Time with a Time Zone added: HH:NN:SS+00:00
The ISO Time in UTC: HH:NN:SSZ
The ISO Combined Date/Time Standards:
YYYY-MM-DD HH:NN:SS
YYYY-MM-DDTHH:NN:SS
YYYY-MM-DDTHH:NN:SS+00:00
YYYY-MM-DDTHH:NN:SSZ
YYYYMMDDTHHNNSSZ
I am going to change my time settings from a single-digit HOUR to a double-digit one though. That’s 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 you have formatted as just Date or Short Date will be switched to ISO Dates. Custom date formats you have in place will not be changed.
Be careful typing in new date values now. If you just type in "1/2" then you'll still get 02-Jan. But if you type in "1/2/22" you'll get 2001-02-22.
ACCESS USERS:
Likewise any existing Short Date fields (which is the default) will be changed to the new ISO Date format. So unless you have any custom date formats, you'll be fine.
Typing in new date values a little bit different than Excel. The field on the form will always keep the same format, unlike Excel where the format may change based on what you type. Assuming Short Dates: Typing "1/2" will give you 2022-01-02. Typing "1/2/22" will give you 2001-02-22
Dates are still stored internally as a number, so you shouldn't have to worry. Any functions like DateAdd, DatePart, Year, Month, Format, etc. should all still work the same. The only time you may have a problem is if you’re importing data from spreadsheets or text files that are formatted differently. Be sure to double-check anything you import!
If you don't change the Windows Short Time setting that I mentioned earlier to show two-digit hours, then even if you use hh:nn to display times, Access will still use the Windows single-digit 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 just making the change myself today, so I'm sure I'll have a lot of tips, tricks, and pointers in the coming weeks. Stay tuned for more! https://599cd.com/ISODates
https://wn.com/How_To_Switch_Microsoft_Windows_To_Iso_8601_Standard_Date_Format_To_Avoid_Date_Confusion_Yyyy_Mm_Dd
In today's video, I'm going to show you how to switch your Windows PC to the ISO 8601 standard date format. This will help you avoid confusion when communicating with people in other countries, and prevent international incidents!
LEARN MORE:
https://599cd.com/ISODates
LINKS:
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
COURSES:
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
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting 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 advantages and disadvantages, global standard date and time format, international date standard, universal date format, short date, two digit hour
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 date standard that's the same for everyone. When you have dates displayed like 4/2/2022, that could mean April 2nd or February 4th, depending on where you're located.
This can be embarrassing on a personal level. "My flight will be landing at noon on 2/3/22." This can be costly on a business level! "To avoid a late fee, your invoice is due on 4/5/22."
I personally have students in almost every country of the world. When people ask me questions, and I reply, it can be very confusing for both of us. The ISO 8601 standard date format is unambiguous. Regardless of where you are, the date 2022-10-03 is always October 3rd, 2022.
Date and time values are ordered from largest to smallest unit of time: year, month, day, hour, minute, second. Each date value has a fixed number of digits, padded with leading zeros. YYYY-MM-DD
Dates may 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 the ISO Short Date.
The ISO Time standard is (local time zone): HH:NN:SS.xx
The ISO Time with a Time Zone added: HH:NN:SS+00:00
The ISO Time in UTC: HH:NN:SSZ
The ISO Combined Date/Time Standards:
YYYY-MM-DD HH:NN:SS
YYYY-MM-DDTHH:NN:SS
YYYY-MM-DDTHH:NN:SS+00:00
YYYY-MM-DDTHH:NN:SSZ
YYYYMMDDTHHNNSSZ
I am going to change my time settings from a single-digit HOUR to a double-digit one though. That’s 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 you have formatted as just Date or Short Date will be switched to ISO Dates. Custom date formats you have in place will not be changed.
Be careful typing in new date values now. If you just type in "1/2" then you'll still get 02-Jan. But if you type in "1/2/22" you'll get 2001-02-22.
ACCESS USERS:
Likewise any existing Short Date fields (which is the default) will be changed to the new ISO Date format. So unless you have any custom date formats, you'll be fine.
Typing in new date values a little bit different than Excel. The field on the form will always keep the same format, unlike Excel where the format may change based on what you type. Assuming Short Dates: Typing "1/2" will give you 2022-01-02. Typing "1/2/22" will give you 2001-02-22
Dates are still stored internally as a number, so you shouldn't have to worry. Any functions like DateAdd, DatePart, Year, Month, Format, etc. should all still work the same. The only time you may have a problem is if you’re importing data from spreadsheets or text files that are formatted differently. Be sure to double-check anything you import!
If you don't change the Windows Short Time setting that I mentioned earlier to show two-digit hours, then even if you use hh:nn to display times, Access will still use the Windows single-digit 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 just making the change myself today, so I'm sure I'll have a lot of tips, tricks, and pointers in the coming weeks. Stay tuned for more! https://599cd.com/ISODates
- published: 22 Feb 2022
- views: 1881