NSC | Set Field Value if a Date Field is set to today's date

Create a Workflow that will set a default value (message) on a field if the preferred date field is set to today's date. The message must show on real-time update and on Edit mode of the record.

1. Navigate to Customization > Workflow > Workflows 

2. Preferred Custom Workflow: Click Edit

3. Click State 1

4. Bottom right corner: Click New Action

5. Click Set Field Value

6. Basic Information:

○ Trigger On: Select After Field Edit

○ Triggering Client Fields: Select Name of Date Field

Example: Date

7. Condition: 

○ Use: Select Custom Formula

○ Formula: Enter nlapiStringToDate(nlapiGetFieldValue('custbody171')).valueOf()==nlapiStringToDate(nlapiDateToString(new Date())).valueOf()

Note: Change the custbody171 to the internal id of the field you prefer to get the value of the date