Solved

Finding the oldest date in a column with the following date format....

Posted on 2013-06-14
4
398 Views
Last Modified: 2013-06-15
My column has the following format.  I tried min and small to find the oldest date but it did not work.  I tried formatting the column to date as well.


2013-06-13 22:31:00.000


Thank you.
0
Comment
Question by:dorianit
4 Comments
 
LVL 15

Assisted Solution

by:Ess Kay
Ess Kay earned 167 total points
Comment Utility
use this tecnique

http://www.techonthenet.com/excel/questions/remove_time.php


needless to say, change the / into a -
0
 
LVL 92

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 166 total points
Comment Utility
If those are actually text values, then try this:

{=MIN(VALUE(E2:E1000))}

Apply appropriate date number formatting.

That's an array formula.  Do not type the curly braces, and use Ctrl+Shift+Enter to finish it off.
0
 
LVL 50

Accepted Solution

by:
barry houdini earned 167 total points
Comment Utility
Try using "text to columns" to convert to "real" date/time values

Select column > Data > text to columns > Finish

Now try using MIN again and that should work.......

regards, barry
0
 

Author Comment

by:dorianit
Comment Utility
Because the data was from a query,  I found that I could just sort the column and figure out the oldest date that way.  With subsequent queries the, column sorts would remain sorted.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Excel 2013 Problem 12 44
identifying alphanumerics in a column 6 18
TT Column Arrange 10 27
VLOOKUP Function MS Excel 2010 2 20
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
This article will show you how to use shortcut menus in the Access run-time environment.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now