Skip to main content

How to Create a Workaround for Required Task Date Fields Using a Custom Today Field

If workflow tasks require Start and Due Dates but you need the current date, system limits can block you. This guide shows how to build a custom "Today" field that updates daily to act as a reliable date source for automations.

Before You Begin

  • Access Level: You must have Administrator access to create custom fields and build workflows.

  • Permissions: Ensure you have permission to modify the specific module layout where the workflow originates (e.g., Leads or Intake Opportunities) and the Tasks module.

  • Use Case: This workaround is specifically designed for scenarios where you need automated tasks to populate with the exact current date values without manual intervention.

Steps

Step 1: Create the Custom "Today" Field

  1. Navigate to SettingsCRM SettingsModule ManagementModule Layouts & Fields.

  2. Select the specific module that will trigger your task workflow (e.g., Leads or Intake Opportunities).

  3. Click + Add Custom Field and configure it exactly as follows:

    • Select Field Type: Date

    • Label Name: Today (or Current Date Workaround)

    • Default Date: Today

  4. Under the Enable/Disable properties, check the Hide option. This ensures the field remains invisible to standard users so they don't accidentally edit it.

  5. Click Save.

Step 2: Create a Daily Update Workflow

  1. Go to Settings → CRM Settings → Automations → Workflows

  2. Click Add Workflow and name it (example: "Update Today Field Daily")

  3. Set Target Module to the same module where you created the Today field

  4. Set Trigger to Scheduled Time (Daily)

  5. Set At Time to early morning (example: 01:00 AM)

  6. Set Delay to 0

  7. Add a condition that applies to all records (example: "Created Time is not empty")

  8. Add an Action to Update Fields

  9. Select the "Today" field and set its value using an Expression

  10. In the expression field, use a function that returns today's date

  11. Set workflow to Active and click Save

Step 3: Use the Today Field in Your Task Creation Workflow

  • In your main workflow that creates tasks, when you reach the Create Task action

  • For Start Date, select the custom "Today" field instead of trying to use a direct "today" value

  • For Due Date, select the custom "Today" field (or create additional date calculation fields if you need future dates)

  • Complete the rest of your task configuration (title, assignee, etc.)

  • Save the workflow

Verification / Expected Result

  • The custom "Today" field will automatically update to the current date each day at the scheduled time

  • Your workflow will successfully create tasks with Start Date and Due Date populated

  • Tasks will have reliable, current date values without manual intervention

  • The Today field remains hidden from users but provides the necessary date reference for automation

Alternative Solution

If you prefer not to use the custom field workaround, you can make the date fields non-mandatory:

  1. Go to CRM Settings → Module Management → Module Layouts & Fields → Tasks

  2. Click on the mandatory button for the Start Date and Due Date fields to make them optional

  3. Save your changes

This allows you to create tasks without requiring date values, though you'll lose the automatic current date population.

Troubleshooting / Common Errors

  • Today field not updating: Verify your daily workflow is active and the scheduled time trigger is properly configured

  • Task creation still failing: Confirm you're referencing the custom "Today" field correctly in your task creation workflow

  • Cannot find the Today field: Check that the field was created in the correct module and verify your workflow target module matches

Related Resources

Did this answer your question?