Master Date Formatting in Make.com: Get Precise Date Outputs Every Time
Struggling with inconsistent date formats in your automations? Whether it's invoices needing the first of the month or reports requiring specific date formats, Make.com's date functions give you complete control. Learn how to manipulate and format dates exactly how you need them.
Date Manipulation Basics
Every automation eventually needs to handle dates - whether it's scheduling future events, calculating due dates, or formatting reports, or standardizing invoice dates. The challenge is that different systems expect dates in different formats, and business rules often require specific date manipulations.
Make.com provides a comprehensive set of date functions that let you transform dates exactly how you need them. The foundation is the now function, which returns the current date and time. From there, you can add, subtract, set specific components, and reformat the date to match your requirements.
Key insight: The same date can be represented in January 28, 2026, 01/28/2026, 2026-01-28, or 28-Jan-2026 format depending on what your workflow requires. Make.com lets you convert between these formats effortlessly.
Adding and Subtracting Time
One of the most common date manipulations is adjusting dates forward or backward in time. This is essential for calculating expiration dates, scheduling follow-ups, or creating date-based triggers.
Make.com provides six functions for adding time:
-
addSeconds(date; number) -
addMinutes(date; number) -
addHours(date; number) -
addDays(date; number) -
addMonths(date; number) -
addYears(date; number)
To subtract time, simply use a negative number as the second parameter. For example, addYears(now; -1) gives you the date one year ago from today.
Pro tip: You can chain these functions together to make complex date adjustments. For example, to get the date 3 months and 15 days from now: addDays(addMonths(now; 3); 15).
Setting Specific Dates
Often you need to standardize dates to specific values, regardless of the original date. Common examples include:
- Setting all invoices to the 1st of the month
- Changing anniversary dates to January 1st
- Standardizing time portions to midnight or noon
Make.com provides "set" functions for each date component:
-
setSeconds(date; number) -
setMonth(date; number) -
setYear(date; number) -
setHours(date; number) -
setMinutes(date; number) -
setSeconds(date; number)
For example, setDate(now; 1) changes any date to the first of that month - perfect for standardizing invoice dates.
Formatting Dates Exactly How You Need
The formatDate function transforms dates into exactly the string format you need. It uses format codes:
- MM - Two-digit month (01-12)
- M - Month without leading zero (1-12)
- dd - Two-digit day (01-31)
- d - Day without leading zero (1-31)
- yyyy - Four-digit year
- yy - Two-digit year
Combine these codes with separators to create your desired formats:
-
formatDate(now; MM-dd-yyyy)→ 01-28-2026 -
formatDate(now; M/d/yy)→ 1/28/26 -
formatDate(now; yyyy-MM-dd)→ 2026-01-28 (ISO format)
Time Formatting
When you only need the time portion or want to format it differently from the date, use these time-specific codes:
- hh - 12-hour format (01-12)
- h - 12-hour without leading zero (1-12)
- HH - 24-hour format (00-23)
- mm - Minutes (00-59)
- ss - Seconds (00-59)
- A - AM/PM indicator
Common time formats:
-
formatDate(now; hh:mm A)→ 02:42 PM -
formatDate(now; HH:mm:ss)→ 14:42:00
Real-World Use Cases
Here are practical examples of how businesses use these date functions:
- Invoice standardization:
formatDate(setDate(now; 1); MM-dd-yyyy)ensures all invoices show the first of the current month - Membership expirations:
formatDate(addYears(now; 1); MM/dd/yyyy)calculates one year from today - Report filenames:
formatDate(now; yyyyMMdd_HHmmss)creates timestamped filenames like 20260128_144200.csv - Payment reminders:
formatDate(addDays(now; 7); M/d/yyyy)shows due dates 7 days from today
Automation pro tip: Combine date formatting with Make.com's text functions to build dynamic strings like "Your payment is due on " + formatDate(addDays(now; 7); MMMM d, yyyy).
Watch the Full Tutorial
See these date formatting techniques in action in our complete tutorial video (at 3:15 for a detailed walkthrough of chaining multiple date functions together.
Key Takeaways
Mastering date formatting in Make.com eliminates one of the most common pain points in automation - inconsistent or improperly formatted dates. With these functions, you can:
- Calculate future/past dates reliably
- Standardize dates across systems
- Create perfectly formatted strings for any purpose
- Build more robust, date-aware automations
In summary: Make.com's date functions give you surgical precision over date formatting and manipulation, ensuring your automations work exactly how your business processes require.
Frequently Asked Questions
Common questions about Make.com date formatting
Use the addYears function in Make.com to add or subtract years. The function takes two parameters - the input date and number of years to add (use negative numbers to subtract).
For example, addYears(now;1) returns the date one year from today, while addYears(now;-1) returns the date one year ago. This same pattern works for months, days, hours, minutes and seconds.
- Positive numbers add time
- Negative numbers subtract time
- Works with any valid date input
The setDate function lets you change just the day portion of any date while keeping the month and year the same. This is perfect for standardizing invoice dates or payment schedules.
Example: setDate(now;1) changes the current date to the first of the current month. The function works with any day value from 1 to 31 (automatically adjusting for shorter months).
- Great for monthly billing cycles
- Maintains original month/year
- Automatically handles month length
The formatDate function accepts format codes to display dates exactly how you need them. Common patterns include:
MM-dd-yyyy for US format (01-28-2026), dd/MM/yyyy for European format (28/01/2026), or yyyy-MM-dd for ISO standard (2026-01-28). You can add text like formatDate(now; 'Invoice date: MMMM d, yyyy').
- MM = two-digit month
- dd = two-digit day
- yyyy = four-digit year
Absolutely. Use time-specific format codes with formatDate: hh:mm A for 12-hour format (02:42 PM), HH:mm for 24-hour format (14:42), or HH:mm:ss with seconds (14:42:00).
This is useful for time tracking systems, shift schedules, or any application where the date isn't needed. Combine with text: "Shift ends at " + formatDate(now; "h:mm A").
- hh = 12-hour
- HH = 24-hour
- A = AM/PM
Nest date functions to perform multiple operations. For example: formatDate(addMonths(setDate(now;1);3);MM-dd-yyyy) first sets the date to the 1st of the current month, adds 3 months, then formats the result.
This chaining approach lets you build complex date logic while keeping your scenarios clean. Each function processes the result of the previous one, working from innermost to outermost.
- Innermost function executes first
- Each function passes its result to next
- Final function determines output format
Nearly every automation that handles dates benefits from these functions. Top uses include standardizing invoice dates, calculating due dates (30 days from today), scheduling future events, and comparing dates in conditional logic, and formatting dates for reports or system integrations.
For example, an ecommerce store might use addDays(now;7) to calculate expected delivery dates, while a SaaS company might use formatDate(addYears(now;1);yyyy-MM-dd) to show subscription renewal dates.
- Billing and invoicing
- Subscription management
- Reporting and analytics
Always explicitly format dates before sending to other systems. The ISO format (yyyy-MM-dd) works universally, while systems like CRMs or accounting software may require specific formats.
Best practice is to store the raw date in Make.com, then create formatted versions as needed. For example: store now in a variable, then create formatDate(myDate;MM/dd/yyyy) for QuickBooks and formatDate(myDate;dd-MMM-yyyy) for Salesforce.
- ISO format (yyyy-MM-dd) is most compatible
- Match the receiving system's expectations
- Store raw date for flexibility
GrowwStacks specializes in building Make.com automations with precise date handling for invoices, reports, scheduling and more. We understand how critical proper date formatting is for business processes.
Our team will:
- Analyze your date formatting requirements
- Build custom date manipulation logic
- Ensure compatibility across all your systems
- Provide documentation and training
Schedule a free 30-minute consultation to discuss your specific date automation needs.
Ready to Perfect Your Date Automations?
Inconsistent date formats create errors and errors across your systems. Let GrowwStacks build you bulletproof date handling workflows in Make.com, tailored to your exact business requirements.