Help request to pop up message for first day of month

[mso3]

Hi friends,

The following code is working fine till the last day of month but not working for the first day of next month. For ex. There are 31 days in January which is the last day of January. The next date is 01/02/16 the first day of month February. In this case the code is not giving message of tomorrow’s birthday because as per the code the next day is 31+1 = 32 which is not a date. The next day is 1 the first day of February.

So what shall I do to recognize the next day 1 instead of 32. It’s same for each last day of month.

Please Login or Register  to view this content.

Any help will be highly appreciated.

Thanking you in anticipation.

[sktneer]

Try changing the following line

Please Login or Register  to view this content.

TO THIS

Please Login or Register  to view this content.

See if that resolves your issue.

[:) Sixthsense :)]

Replace this

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

[mso3]

Hi Sktneer & Sixthsense,
Thank you for amendment. Both the amendments are working for the current year only and not for previous and next years.

There are 3 birthdays on 01/02/.. Here the year of birthday of each one is different but only the day and month is same for 3 contacts.

I want a pop up message for all these 3 contacts.

Thanking you.

[sktneer]

Try this and see if this works...

Please Login or Register  to view this content.

[mso3]

Hi Sktneer,
Excellent! Now it's working fine.

Thank you and have a nice day.

[sktneer]

You're welcome. Glad I could help.