Setting the Value Parameter of On Field Update Set
The Value parameter can contain an expression. If Siebel CRM updates the Done Flag in the following example, then it uses an IIF expression to set the Done field:
"Done Flag", "Done", "IIF ([Done Flag] = "Y", Today (), "")"
Any expression you use must evaluate to the same data type that the target field uses. In the following example, Siebel CRM uses the ToChar function to convert the date to a string before it concatenates it with another string and sets the field value:
"Agreement Start Date", "Name", "ToChar([Agreement Start Date])+ [Agreement Type]"