REGEX Date Validation with 3-Week Fallback
Checks 'Close Date' using REGEX for YYYY-MM-DD format. If valid, passes it; else, sets date to 3 weeks from now. Ideal for ensuring reliable date handling in automations.
This n8n workflow demonstrates practical REGEX usage in an IF node to validate a 'Close Date' field. Starting with a Manual Trigger, it sets an initial date value. The core IF node tests if the Close Date matches the pattern /\d\d\d\d-\d\d-\d\d/i (case-insensitive YYYY-MM-DD). If matched, it routes to 'Set Close Date To Original', preserving the value. If not, it generates a fallback date three weeks ahead using JavaScript's Date API: new Date(new Date().setDate(new Date().getDate() + 21)).toISOString(). The flow ends at a NoOp node for output viewing.
Benefits include robust date validation preventing invalid data propagation, automated fallback for missing/invalid dates, and easy testing via toggling the initial Set node. It's lightweight, using only core n8n nodes, making it efficient and customizable.
Use cases span education (e.g., student enrollment deadlines), CRM (opportunity close dates), project management (task due dates), or any scenario needing conditional date logic. Adapt for production by swapping Manual Trigger for webhooks/APIs and integrating with tools like Google Sheets or databases.
New buyers can create an account from the cart to unlock a controlled $10 first-purchase credit on eligible orders of $25+.
Related bundle
E-commerce Store Automation Suite
8 hand-picked workflows for $39.00.
That is $4.88 each, vs $7.99 for this one alone.
View bundleSecure checkout powered by Stripe
Tags
Support
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related Education workflows
- Learn JSON Basics with an Interactive Step-by-Step Tutorial for Beginners$14.99
- Learn n8n Expressions with an Interactive Step-by-Step Tutorial for Beginners$14.99
- Automated AI Degree Audit Using Google Sheets and OpenAI$9.99
- Learn API Fundamentals with an Interactive Hands-On Tutorial Workflow$24.99
- Master Webhook Integration and Security with Supabase in n8n$14.99
- Master JavaScript Code Node with Interactive n8n Tutorial$9.99
More from Vera Petrova
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.