Tuesday, September 25, 2018

Custom Formula Field to Display Date Value

Example:

X = custbody_datetoday  (Date field)
Y = custbody_numofdaysprocessed  (Free-Form Text field but has integer value)
Z = Custom Formula field (Free-Form text field)

X = 3/15/2011
Y = 4
Z = 3/19/2011 

 
Below are the steps to create a custom formula field (Z).

1. Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New
2. Provide the name of date field on Label.
3. Set the Type = Free-Form Text
4. Store Value = F
5. Under Applies To Tab, select Customer
6. Click the Validation & Defaulting Tab
     Formula = T 
     Default Value = TO_CHAR({custbody_datetoday}+TO_NUMBER({custbody_numofdaysprocessed}),'mm/dd/yyyy')
7. Hit Save (or Save & Apply To Forms button)

* The formula may be applicable also on saved searches.

No comments:

Post a Comment