Entering date in a cell so that it falls in specific way when sorted?

[Jones]

I have an entry that I know falls in February 2004 but that we don't
have an exact date for as that information has been lost (ahem, _not_
may I say by me [thank goodness!] <lol>). Anyway, all the other
entries for this date column are in the usu. m/d/yyyy format even
though they have a custom setting that has it display differently.

My problem is one I've run into many times before - how to have a,
say, 2004.02 entry (for Feb.2004) sort between the last January 2004
one and the first February 2004 one? Is it possible to enter the
Feb.2004 date in such a way that it will sort "properly"??

Thank you!

 

[Frank Kabel]

Hi
the only idea I have:
- first enter this date as 2/1/2004
- use a helper column to tag these entries (e.g. insert a 'X' for these
records in this helper column)

Now sort using both columns

 

[hglamy]

Frank, you are simpy one of the best !

Hi
the only idea I have:
- first enter this date as 2/1/2004
- use a helper column to tag these entries (e.g. insert a 'X' for these
records in this helper column)

Now sort using both columns


--
Regards
Frank Kabel
Frankfurt, Germany

I have an entry that I know falls in February 2004 but that we don't
have an exact date for as that information has been lost (ahem, _not_
may I say by me [thank goodness!] <lol>). Anyway, all the other
entries for this date column are in the usu. m/d/yyyy format even
though they have a custom setting that has it display differently.

My problem is one I've run into many times before - how to have a,
say, 2004.02 entry (for Feb.2004) sort between the last January 2004
one and the first February 2004 one? Is it possible to enter the
Feb.2004 date in such a way that it will sort "properly"??

Thank you!

 

[Jones]

Hi
the only idea I have:
- first enter this date as 2/1/2004
- use a helper column to tag these entries (e.g. insert a 'X' for these
records in this helper column)

Now sort using both columns

Frank, thank you for your response.

I wanted to do this without adding an extra column to fiddle with. I
needed to do something to the text entered in the date so that it just
automatically sorted properly so this idea wouldn't actually work.

However, your response triggered something that _will_ do the job; so
after all these years I've ever had this problem, thank you so much
for inadvertently leading me to an almost perfect solution! <g>

D'UH!! I'll enter the date as 2/1/2004, as you say, but I'll CHANGE
THE DISPLAY from "yyyy.mm.dd.ddd" to something like "Feb.2004"!!!
That will be awesome! Other users will in all likelihood never notice
this but I'll probably just add a comment in that cell in case they
ever wonder and want to change things. (But probably they'll never
notice or care.) So it'll sort after the January 2004 entries but
will appear before the first February entry which happens to occur
around the 14th! Awesome!

I should have mentioned that I might be creating all these files, but
I'm just a temporary contractor so they're going to be left behind for
others to use. So I have to keep it very, very simple. I have a
dozen such log sheets and to have just this sheet have an extra column
just so it would sort ONE entry "properly" would not be a viable
solution whereas changing the display manually myself for this one
instance is.

Thank you so much! <g> I really appreciate the help; it doesn't
matter how a solution is found as long as the problem is solved!

I have an entry that I know falls in February 2004 but that we don't
have an exact date for as that information has been lost (ahem, _not_
may I say by me [thank goodness!] <lol>). Anyway, all the other
entries for this date column are in the usu. m/d/yyyy format even
though they have a custom setting that has it display differently.

My problem is one I've run into many times before - how to have a,
say, 2004.02 entry (for Feb.2004) sort between the last January 2004
one and the first February 2004 one? Is it possible to enter the
Feb.2004 date in such a way that it will sort "properly"??

Thank you!