Is Today someones birthday? Send them an email.

[thebloke]

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

[-Queue-]

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))

[Damocles]

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

Happy to say, I knew that!

[thebloke]

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.

[-Queue-]

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.

[Ben Jackson]

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!

[Fenton]

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.