Sorting Dates when there are zeros in the month and/or day

K

ktbull

I need to sort a column of date values that contain valid dates (i.e.
12/12/1990) as well as dates that contain zeros in the month and or in the
day (i.e. 01/00/1990 and 00/01/1990). I have managed to blend the missing
day dates into the range using mm/yyyy as my format, but I can not get the
dates with the missing months to incorporate. Any tips?

Thanks in advance.
 
B

Bob Alhat

Why are there missing days or months? Is this material to your data - that
is, should these examples remain this way?

The values with the missing days/months will be text entries, hopefully
those without missing elements will be numbers displayed as dates (numeric
constants). If you change the dates to text, your sort might work.

HTH
Roger
Shaftesbury (UK)
 
K

ktbull

The days or months are missing due to not being able to get the information
due to illegibility or simply not having it. I will try the text format to
see if that works. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top