How do i sort column of date of birth (format dd-month-year)?

E

Excel user

How do i sort ascending a column of dates of birth (format dd-mm-year) by
day, and month? Let's say, the Column C is 'Date of birth' and the first
client B2 is 28-August-1962, the second is B3 is 30-May-1972 and the third B4
is 03-June-1966.
Thank you !
 
J

Jeff Boyce

You posted in an Access newsgroup. I assume you want an Access answer.

Create a query. Create a new field, and use the Month() function on your
DOB field to get month-of-birth. Create another new field and use the Day()
function ....

In your query, sort on these two fields.

Regards

Jeff Boyce
<Office/Access MVP>
 
S

Stephen Glynn

Sorry, I don't understand. If all he wants to do is sort a column of
dates in ascending order, then all he needs to do is specify 'ascending'
as the sort order in the query design grid, doesn't he? What does he
need the two extra columns for?

Steve
 
D

Duane Hookom

The OP asked to sort the records "by day, and month". That suggests some
order that is not in date order which is basically by year, month, day.
 

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

Similar Threads

How do I get ACCESS to calculate years, months, days for a birth d 2
Excel function to convert month-day-year to mm/dd/yyyy 7
Formula to fill cells based on Date of Arrival and Date of Departure 1
how to sort a column containing date of birth? 1
Converting MM/DD/YYYY into just MM/DD and Sorting 1
Sorting a date by month, date and then year. 3
Extract Month and year from Cell containing date, month, year & time 2
Expiration date based on 5 years and Birth month,day ... 4

Top