"In other words, a sort ascending will always place a record with a year of 1965 before a year of 1966 or later, regardless of month and date."
Yet this is also true of FileMaker date and timestamp data types.
And with proportional fonts used in most reports, the fact that you get good alignment with a mono spaced font seems of little value.
But hey, just because I don't see much use for it doesn't mean others won't find it useful.
1. take a look at this thread (particularly the calc by user19752):
a very cool way to get the date as YYYYMMDD! sure, it's not your dashed dates, but the entire thread is interesting.
2. Also to note, the ExecuteSQL() calling date, time and timestamp fields will result in this format:
(because it's SQL!)
3. And vote on this Idea to expand the formats 'natively' in FileMaker:
4. I really like this custom function for dates, as it's more closely relates to the php formats and is very flexible (possibly allowing for your needs?):
2 of 2 people found this helpful
You might consider posting your CF on FileMaker Custom Functions | Home
May I recommend a technique I've been using for a while for adding leading zeros ...
Right ( "0" & Month ( ts ); 2 ) & "-" &
Thanks Beverly! I voted on that one, it is up to 7 now
Glad I'm not the only one who pines for one international standard that is sorted the same way natively without regard to field type.
Thanks David that's pretty slick method too, just add a leading zero and pull the right two characters thus truncating the 0 on Oct to Dec on a Month, for example. Very nice!