Schedule Calls with Clients Where the Birthday Is Within Six Months and Is Not in the Current Week

This workflow rule is triggered when a producer updates the Call Frequency field on the contact (client) record to 1-2 Times/Year. If the birthday of the client is not more than six months from now and is not within the current week, the workflow rule creates a birthday call task to call the client one week before the birthday.

Note: The expressions in this topic might appear across several lines due to length. All expressions in this topic must be entered in Expression Builder as one line and cannot contain any spaces. Also, the language-independent field names and the field-name syntax used in the expressions in this topic are the field names and syntax that were used in Expression Builder in releases earlier than Release 29 Service Pack 1. These expressions are still valid in Release 29 Service Pack 1 and later releases. However, starting with Release 29 Service Pack 1, Expression Builder uses language-independent field names and a field-name syntax that are different from the field names and the field-name syntax used in earlier releases. So, if you select the corresponding fields from the field list in Expression Builder when you create or update an expression in Release 29 Service Pack 1 or a later release, then the field names in the expression will be different from the field names shown in this topic, and the fields will appear in the expression editor with the following syntax: [{FieldName}]. It is recommended that you always select the fields for your expressions from the list of fields in Expression Builder, so that the field names and the field syntax are always correct. For more information about Expression Builder, see Oracle CRM On Demand Online Help.

Workflow Rule Details

This topic describes the details of the workflow rule.

Record Type

The record type is a Contact record.

Trigger Event

The trigger event is When New Record Saved.

Rule Condition

The Workflow Rule Condition field contains the workflow rule condition.

Enter the following expression in the Workflow Rule Condition field:

[<CallFrequency>]=LookupValue('PROF_CALL_CLASS','1-2 Times/Year') AND [<DateofBirth>] IS NOT 
NULL AND (JulianDay(IIf(JulianDay(Mid([<DateofBirth>], 1, 6) + ToChar(Today(), 'YYYY')) 
< JulianDay(Today()), Mid([<DateofBirth>], 1, 6) + ToChar(Today()+Duration("P1Y"),'YYYY'),Mid
([<DateofBirth>],1, 6) + ToChar(Today(), 'YYYY'))) <= JulianDay(Today()+Duration("P6M"))) AND 
(JulianDay(IIf(JulianDay(Mid([<DateofBirth>], 1, 6) + ToChar(Today(), 'YYYY')) < JulianDay
(Today()), Mid([<DateofBirth>], 1, 6) + ToChar(Today()+Duration("P1Y"),'YYYY'),Mid(
[<DateofBirth>],1, 6) + ToChar(Today(), 'YYYY'))) > JulianDay(Today()+7))

Workflow Action Details

This topic describes the details of the workflow action.

Action Type

The action type is Create Task.

Task Type

The task type is a Birthday Call.

Due Date

The Due Date field contains a numeric value that is calculated by adding the value in this field to the date on which the task is created.

Enter the following expression in the Due Date field:

Today()+JulianDay(Mid([<DateofBirth>],1,6)+IIf(JulianDay(Mid([<DateofBirth>],1,6)+ToChar(Today(),
'YYYY')) < JulianDay(Today()),ToChar(Today()+Duration("P1Y"),'YYYY'),ToChar(Today(),'YYYY')))
-JulianDay(Today())-(IIf(IfNull(Mid(1.0*(JulianDay(Mid([<DateofBirth>],1,6)+IIf(JulianDay(Mid(
[<DateofBirth>],1,6)+ToChar(Today(),'YYYY')) < JulianDay(Today()),ToChar(Today()+Duration("P1Y"),
'YYYY'),ToChar(Today(),'YYYY')))-7)/7,8,1),"0")>="7",(IIf(IfNull(Mid(1.0*(JulianDay(Mid(
[<DateofBirth>],1,6)+IIf(JulianDay(Mid([<DateofBirth>],1,6)+ToChar(Today(),'YYYY')) < 
JulianDay(Today()),ToChar(Today()+Duration("P1Y"),'YYYY'),ToChar(Today(),'YYYY')))-7)/7,8,1),
"0")="7",5,6)),7))

Subject

The Subject field contains the subject line for the task. You can embed functions and field names in the text. Three percent signs (%%%) before and after an embedded function or field name indicate that it is to be converted to a string.

Caution: In the Subject field, three percent signs (%%%) are placed before and after the functions and field names. If you type a function or field name directly in the Subject field, you must type three percent signs before and after it. If you use Expression Builder to embed a function or field name, the percent signs are automatically added and must not be pasted into Expression Builder. When percent signs are pasted into Expression Builder, Expression Builder displays an internal error.

For more information about expressions, see Oracle CRM On Demand Online Help.

Enter the following expression in the Subject field:

%%%LookupValue("TODO_TYPE", "Birthday Call")%%% %%%FieldValue('<ContactFullName>')%%%