# Is Today someones birthday? Send them an email.

This topic is 7061 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

Trolling the forum today I found some helpful things regarding Birthday Calculations.

I thought I would post the fruit sof my labors.

Here is a calculation field that will return a 1 if today matches the month and day in the DOB field.

If today does not match then it returns a zero.

Note: that I use the Status(CurrentDate) for the Month(date) and Day(Date) funtions.

If((Month(DOB) &"/"& Day(DOB))=(Month(Status(CurrentDate)) &"/"& Day(Status(CurrentDate))),1,0)

I am going to use this calculation field in a daily script that will run using Oazium Events that will look for all people who have a birthday today and send them an email wishing them a happy birthday.

hope this inspires someone to greatness.

the ohio bloke

##### Share on other sites

You don't need an If( ), by the way, since the test results in a boolean.

Month(DOB) & "/" & Day(DOB) = Month(Status(CurrentDate)) & "/" & Day(Status(CurrentDate))

##### Share on other sites

You don't need an If( ), by the way, since the test results in a boolean.
Happy to say, I knew that!
##### Share on other sites

Well I did NOT know that ... thanks for the heads up.

I am assuming then that any calculation can be made boolean by adding

, 1 , 0

at the end of the statement.

##### Share on other sites

In general, if you have an If or Case statement with "1, 0" at the end, then it is redundant and you can remove the statement and leave the test because it results in either true or false (1 or 0).

If you want to go the other way around, i.e. "0, 1", prepending a simple "not" to the test will do the trick.

##### Share on other sites

• 3 months later...
• Newbies

what am i missing here, when I put this calculation in it says there is no such function as 'status'... what's that all about?

thank you!

##### Share on other sites

In version 7 it's Get ( CurrentDate ), or in this case:

Month(DOB) & "/" & Day(DOB) = Month(Get ( CurrentDate )) & "/" & Day(Get ( CurrentDate ))

All the Status() functions are now Get() functions.

##### Share on other sites

This topic is 7061 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account