02-10-2023, 06:15 AM
Edited to include some notes for documentation into the original post. If any of you guys have copied this for your "toolbox", I'd suggest replacing what you already have with the latest version, as it's commented well enough to describe the custom formatting which one can use to generate a date in whatever format they'd like to view it in.
If anyone has any questions, feel free to ask and I'll answer them for you. Biggest thing to remember is:
1. We have "short" and "long" versions of everything except our year.
2. Basic format is "M"onth, "D"ay, "Y"ear, "W"eekday.
3. Short versions are usually just the number, long versions are names or include strings.
"d" is just the day. "01" for the first day of the month. "27" for the 27th day of the month.
"D" is the day with the "st, nd, rd, th" to it. "01st" or "27th".
4. For months, we actually have 3 codes -- "E"xtended months, long "M"onths, short "m"onths.
"E" = "February"
"M" = "Feb"
"m" = "02"
5. Anything not a "WwEMmDdYy" is considered part of your custom formatting so you can add spaces, commas, dashes, or slashes to your hearts content to separate those elements.
"StarCount: mm.dd.yyyy" would process and return as "StarCount: 02.10.2023", though *why* you'd want it to return that, is beyond me. I'm just saying that you could use it and get it back in that format. Anything NOT "WwEMmDdYy" is just counted as spacer/formatting separators, so be aware of that in case you make a typo. (IE you use "mn-dd-yyyy", you'll get results that look like "02n-10-2023".)
And that's more or less it.
If anyone has any questions, feel free to ask and I'll answer them for you. Biggest thing to remember is:
1. We have "short" and "long" versions of everything except our year.
2. Basic format is "M"onth, "D"ay, "Y"ear, "W"eekday.
3. Short versions are usually just the number, long versions are names or include strings.
"d" is just the day. "01" for the first day of the month. "27" for the 27th day of the month.
"D" is the day with the "st, nd, rd, th" to it. "01st" or "27th".
4. For months, we actually have 3 codes -- "E"xtended months, long "M"onths, short "m"onths.
"E" = "February"
"M" = "Feb"
"m" = "02"
5. Anything not a "WwEMmDdYy" is considered part of your custom formatting so you can add spaces, commas, dashes, or slashes to your hearts content to separate those elements.
"StarCount: mm.dd.yyyy" would process and return as "StarCount: 02.10.2023", though *why* you'd want it to return that, is beyond me. I'm just saying that you could use it and get it back in that format. Anything NOT "WwEMmDdYy" is just counted as spacer/formatting separators, so be aware of that in case you make a typo. (IE you use "mn-dd-yyyy", you'll get results that look like "02n-10-2023".)
And that's more or less it.