Showing upcoming Birthdays

[#1]

Dear friends,

Was looking at creating a tool to show upcoming birthdays for Customer Relationship Management. My intention is to show the upcoming birthdays for say a 2 week period both the age of the person.

Any ideas on how to look at this?

I can tabulate the age of the person by

=year(today())-year(birthday)

I can't seem to find a way to isolate upcoming birthdays though.

Any ideas?

Thanks again, and any help will be appreciated!

[#2]

Thanks Manoj, that was the intention. But I was hoping to highlight upcoming birthdays 2 weeks in advance instead of highlighting it on the day itself.

[SunilChauhan]

see the attached file

hope this helps

[#4]

love your tool and the highlights!

The birthdates that you keyed in are all 2014, how do I make it work with birthdates that have years like 1970, 1992 etc?

Thanks so much!

[SunilChauhan]

That is the sample date provided in birthday field

you can add your date .it will work for you as well.

it will take 1970  as Not highlighted , as they are passed.

so this example will highlight the dates which are due in 2 week or 14 Days.

Remainig dates are not highlighted as they are

1) either passed

2) or more than 14 days

hope this make sense

[CELAMBARASAN]

Attached might helps

[#7]

Hi,

Try like this

1. Provide 1 input box with a variable (Ex: vWeekInput) to enter number of weeks.

2. Use this expression in a chart against a dimension (Ex:Customer)

IF(Date(Date(Today())+vWeekInput*7,'DD/MM/YYYY')- Date(Today(),'DD/MM/YYYY')>=vWeekInput*7,Date(Date(Today())+vWeekInput*7,'DD/MM/YYYY'))

Note:

Date(Date(Today())+vWeekInput*7,'DD/MM/YYYY')  ---> This is your existing Birthday field like,

Date(Birthday,'DD/MM/YYYY')

Regards

Kumar