This one's very "me" but might give you some ideas.
I generally do dates/times in one of six different formats:
- 28/01/2023 -- some internal forms
- 28-01-2023 -- other internal forms (and yes, I wish they'd standardise!)
- 28 Jan 2023 -- style guide for written dates
- 2023-01-28T19:29:35+0000 -- work's "full ISO" timestamp
- 2023-01-28T193012+0000 -- log-style timestamp
- 2023-01-28193033+0000 -- old-style timestamp
...and use a typed string that is
;
-- because all* my text expansions start with that//
-- because FileMaker's "today" symbol is ingrained!- None or one of
-ilou
;
-- because all* my text expansions finish with that
So ;//;
expands to the default "28/01/2023", ;//u;
to "28 Jan 2023", etc.
Date Entry.kmmacros (6.9 KB)
* "All" isn't very many because I don't often think to create them, and seldom remember to use them when I do! Seeing @ccstone's examples above makes me think I should try harder at both -- thanks for the push, Chris!