I'd switch my system over to that just because I use that same date format for my backup files and finance reports/bank statements. Much easier to find when it's year first followed by the month. The entry rule is going to drive me nuts until I get used to it however. And time format - it will be cold day in....... before I change that. Thank you for the video.
It's really not that bad entering dates for THIS YEAR because you can still just type in 12/5 for Dec 5, for example. It's only when you have different years that you have to remember to put the year first.
Hi Rick! Very nice tutorial as usual. Even though I setup all my filelds into ISO format, I keep getting upside down format when I'm filtering one date field according to another date field. For example: 04/06/2022 will filter as it was like 06/04/2022 (as long as the 2 first digits are between 01 and 12 the system treats the string like even though I specified the ISO format everywhere...) All other dates that are 13/XX/XXXX and above - are treated well. can you figure out why it is happening?
Honestly, I'm not sure. Could be something with your regional settings. All I can say is it works fine for me here in the US, and my friends in the UK say it works fine for them.
I'd switch my system over to that just because I use that same date format for my backup files and finance reports/bank statements. Much easier to find when it's year first followed by the month. The entry rule is going to drive me nuts until I get used to it however. And time format - it will be cold day in....... before I change that. Thank you for the video.
It's really not that bad entering dates for THIS YEAR because you can still just type in 12/5 for Dec 5, for example. It's only when you have different years that you have to remember to put the year first.
Great format for index cards and paper files.
I think so too!
Hi Rick!
Very nice tutorial as usual.
Even though I setup all my filelds into ISO format, I keep getting upside down format when I'm filtering one date field according to another date field.
For example: 04/06/2022 will filter as it was like 06/04/2022 (as long as the 2 first digits are between 01 and 12 the system treats the string like
even though I specified the ISO format everywhere...) All other dates that are 13/XX/XXXX and above - are treated well.
can you figure out why it is happening?
Honestly, I'm not sure. Could be something with your regional settings. All I can say is it works fine for me here in the US, and my friends in the UK say it works fine for them.
ISO is yyyymmdd not ddmmyyyy
Hi Richard, my code for now() was working in access vba but now in february, it results with month and dates are changed
That's weird
I unknowingly started to use ISO 8601 date format when I wanted to sort files using dates for the file names...
It's a good system for that. :)
10:09 at this point it seems confusing now ://
Nah... you get the hang of it. My only problem is that the VBA editor still defaults to the traditional month-day-year format.
remember kids, colon is not allowed in windows file names and 20231212T160034 is ugly to read.
Yeah I usually replace them with dashes and file names so you end up with 2024-12-01.JPG or whatever