Salesforce Docs Portal

Use Case 6: Add the Date and Time Field to Engagement Streams

This use case locates engagement streams that have no set date and updates them since a date is required.

Raw Data Goal
Raw data has no date, but you want to set the data as Category = “Engagement”. Create the formula field “Today’s Date” and set the formula to the “Event Date & Time” on Object Details.
  1. For Field Label, enter Today’s Date.
  2. For Formula Return Type, select Date.
  3. In the syntax editor, enter the formula: TODAY().
  4. Click Save.
  5. Verify that “Today’s Date” is added as a field.
  6. In Object Details, select the new field for Event Date & Time.