How to sort on birthdays

G

geekseeker

What fields would best to be used in creating a customed calendar view that
would show birthdays sorted on the day of the year without regard to the year
of birth?

So far, all the date-related fields I have tried seem to be sensitive to the
year of birth, for example from the personal fields within my contact list.
My birthday data comes from both contact as well as calendar-only entries. I
would like the list of birthdays to be sorted forward from the current date.

Thanks for your help.
 
D

Diane Poremsky [MVP]

I used the recurrence contains jan, feb, mar etc for filtering months. but
you won't be able to sort them in order (it'll sort alphabetically).

See http://www.outlook-tips.net/views/birthday.htm for the method I use.

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
(e-mail address removed)

EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.
 
G

geekseeker

Thanks Diane for the replay and the reference. Both were helpful.

Since posting my intial inquiry, I developed a user-created,
formula-calculated field which I call "day of the year" which is defined by
this expression: [Birthday]-DateSerial(Year([Birthday]),1,1) You can
substitute any date field such as start or recurrence for birthday and it
works as well - given that you filter the data appropriately for birthdays.

This field provides the number of the day within a year for each birthday
regardless of the year of the birthday. I use this field in creating
calendar or contact views. Only problem is that Outlook will not allow you
to sort on a calculated field. So I copy the view into an excel sheet and
then sort on the "day of the year". This gets all of the dates in order.

There is another alternative which involves creating a new form, but that
involves converting the standard form for contacts or calendar (for which
there are 100's of entries)... Not worth it.

Thanks again ... if you know of a way to sort of a calculated field that
would be most helpful.

Diane Poremsky said:
I used the recurrence contains jan, feb, mar etc for filtering months. but
you won't be able to sort them in order (it'll sort alphabetically).

See http://www.outlook-tips.net/views/birthday.htm for the method I use.

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
(e-mail address removed)

EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.


geekseeker said:
What fields would best to be used in creating a customed calendar view
that
would show birthdays sorted on the day of the year without regard to the
year
of birth?

So far, all the date-related fields I have tried seem to be sensitive to
the
year of birth, for example from the personal fields within my contact
list.
My birthday data comes from both contact as well as calendar-only entries.
I
would like the list of birthdays to be sorted forward from the current
date.

Thanks for your help.
 

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