I have a field where I want the display to be in text, but when I sort, I
want to sort by date. Here's my dilema, though. I sometimes need to report
specific dates (Jan 13), but other times, just the month (Jan). Then, on
the sort, I want it to return them grouped together.

Currently I have a custom date format of 'mmm dd' so my display is 'Jan 13'.
When I just type in 'Jan', it automatically changes it to 'Jan 01' to match
my format...don't want that.

So, how can I get a format that will display 'Jan 13' or 'Jan' if it's just
a month (but still let me sort on that column so all the Jan's are together,
all the Feb's are together, etc.)

Thanks in Advance,
Dave