Sorting by Day in Date Column Advanced Filter


New Member
Outlook version
Outlook 2010 32 bit
Email Account
I use BCM with Outlook 2010 for my insurance business. I use an advanced filter for my clients to send them birthday cards. The filter is designed to show me all active clients who have a birthday in the current month. I would like to sort the date column so that the birthdays would be order according to the day of the month. Since they all have different years I haven't been able to figure out how to sort by just the day portion of their birthdate only so they would be listed in ascending order starting with the first of the month so I could just go down the list sequentially as I go through the month to send them birthday cards. Any help would be greatly appreciated!

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I have this one that uses the pattern - it doesn't sort by date properly because of how numbers-as-text sort when you have 1 and 2 digit numbers.

In order to sort properly, you need a custom field for the month and day, using 2 digits each if using a text field (0831) or as number (831) if using a number field - either way you will need to use a macro to set the field value.
Thread starter Similar threads Forum Replies Date
D Question re: Grouping by Due Date vs. Sorting by Due Date Using Outlook 1
J Outlook 2013 Sorting and grouping on 2 date fields Using Outlook 1
M 2010: sorting by ORIGINAL send date Using Outlook 1
P Sorting Task List so tasks with no due date end up at the bottom Using Outlook 4
E Mail sorting view issue Using Outlook 1
P Is there any way of sorting the task list in CALENDAR view? Using Outlook 4
M Sorting messages by read/unread status Using Outlook 8
B How do I REALLY disable Outlook Junk E-mail sorting in OL2010 and/or 2013? Using Outlook 1
M Sorting "sent emails" is not logical. Is there a better way. Using Outlook 4
D Macro for sorting email according to sender and subject Using Outlook 0
S Sorting by combined categories in Outlook Using Outlook 1
R Sorting and crossing over project tasks in project window (BCM 2010) BCM (Business Contact Manager) 1
B Sorting suggested times in room finder Using Outlook 1
G Outlook 2003:Inbox 'FROM' sorting option Using Outlook 1
S Sorting out sent messages. How can I consolidate 3 sent message directories and successfully retain sent messages across 3 differnt computers using th Using Outlook 2
M Re: Outlook 2010 - Email folders sorting constantly changing Using Outlook 2
B Contacts not sorting in "File As" sort order Using Outlook 3
B Sorting Contacts by Birthday or Anniversary Using Outlook 6
M Strange sorting in sort by day Using Outlook 2
G Managing / Sorting Address Book Contacts into groups Using Outlook 1
A Sorting of existing contact in Outlook 2003 just will not sort Using Outlook 2
O e-mail list sorting Using Outlook 4
B Sorting of Folders in Outlook 2010 Using Outlook 2
A Sorting by categories in Outlook makes items in a folder disappear Exchange Server Administration 5
Q Sorting tasks by calculated field - automatically update task-fiel Outlook VBA and Custom Forms 9
C Outlook with Office365 - search across account, by date rate, in multiple folders - how? Using Outlook 1
V Date and/or time error in Outlook Form Outlook VBA and Custom Forms 0
S Body text of Email from invite date/time Outlook VBA and Custom Forms 7
V 10 Years calenders -single date together Exchange Server Administration 8
O Export Outlook calendar appointments by filters and date range Outlook VBA and Custom Forms 1
D Add date next to day name in Outlook Today calendar view Using Outlook 1
X If you change expiration date of repeated task it dupplicates Using Outlook 1
D Archive by receive date not working Using Outlook 2
V Making a Date field mandatory in outlook form Outlook VBA and Custom Forms 2
P Auto Insert Current Date or Time into Email Subject Outlook VBA and Custom Forms 2
L Ctrl Alt d date stamp use Using Outlook 1
A Create date folder and move messages daily Outlook VBA and Custom Forms 1
witzker Outlook 2010 Insert Date & Time at the button of an OL contactform in red Using Outlook 2
O Tasks - Is there a postponed date column? Using Outlook 7
J Command Button to stamp a date and time in a textbox in Outlook 2016 Outlook VBA and Custom Forms 3
K Outlook Archive to PST Files by Date Range VBA Script? Outlook VBA and Custom Forms 1
W Save and rename outlook email attachments to include domain name & date received Outlook VBA and Custom Forms 4
F Finding Meetings/Tasks in a date range Using Outlook 1
W Save Outlook attachment in network folder and rename to current date and time Outlook VBA and Custom Forms 18
M Macro to add date/time stamp to subject Outlook VBA and Custom Forms 4
V Changing default date for task follow-up buttons Using Outlook 2
J Old unread emails on current date (MDaemon Server) Using Outlook 1
D Outlook macro with today's date in subject and paste clipboard in body Outlook VBA and Custom Forms 1
C Need VBA code to automatically save message outside outlook and add date Outlook VBA and Custom Forms 1
B Search by date macro Outlook VBA and Custom Forms 0
Similar threads