Quote:
Originally Posted by Kythe42
Well I had changed all the dates to yyyy/mm/dd format when I got that strange sorting with the partial dates in my example where the yyyy dates ended up getting sorted partway through the yyyy/mm dates. I did also set the composite column to sort by date right from the start. It doesn't really matter though. I don't have any real dates that are yyyy/mm, just full dates or just the year. I was simply curious about why that was happening.
|
Hmmm... It shouldn't happen and doesn't happen for me with either the old or the new db. See the screen capture.
I can't explain why you are getting something different unless you are entering spaces in the dates somewhere.
Quote:
The test y thing worked. I had actually tried that before in several variations, but I thought I had to tack it on to the end of the template rather than enclosing everything else inside the test y. So no more phantom dates.
Thanks again for all your help.
|
You are welcome.