A particularly useful attribute of this is for date fields. Anniversary dates, Birthdates, Expiration Dates can all be customized to meet various needs.
In this example, we are using the Licenses and Certifications Table from a SmartList Builder Item and creating a Reminder that will always let the user know of any Licesnses or Certifications that are expiring in the next 30 days.
Rolling Dates: Licenses and Certifications Rolling 30 day period
1. Open SmartList Builder by going to Tools>>SmartList Builder>>SmartList Builder
2. Create Licenses and Certification SL Builder Item based on below table:
3. After Saving this choose the Calculations Button on the main SmartList Builder Screen and Click the + sign from the main Calculated Fields Screen.
4. Create the Calculated Field below by expanding the TW_UPR_MSTR_License_Cert table and then double clicking the Expiration Date field highlighted below. In the Calculation Box on the left hand side, manually type in "-30" (minus 30) after the date field as show below. Make sure you type in an appropriate field name and the Field Type will be Date.