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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 !
 
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>
 
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
 
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.
 
Back
Top