tr Skip to content
Black Friday FlowMattic for life, 12 payments of $33.25 Or $399 once. Nothing added for splitting Ends in --Days --Hrs --Min --Sec See the deal

Date Time Formatter: Reformat, Shift and Convert Any Date

FlowMattic Date/Time Formatter: a UTC timestamp from a WooCommerce order is converted to London time and a readable format for the customer email.

Dates break more automations than almost anything else. One app sends 2026-10-04T09:12:00, the next wants 04/10/2026, a third wants a Unix timestamp, and your customer wants it in their own time zone. FlowMattic’s Date/Time Formatter is a date time formatter built into the workflow builder, with thirteen actions to reformat, shift, compare, convert and calculate dates between the trigger and the action.

It is for store owners sending reminders, agencies building reports on a calendar, SaaS teams tracking trials and anyone moving dates between apps that disagree on format. This guide covers every action, the format options, the fields each one returns, and seven workflows that use them.

What is the Date/Time Formatter?

Date/Time Formatter is a built-in action app in FlowMattic. You add it as a step, choose an action, map a date from the trigger or an earlier step, and the result becomes a field for the steps that follow. In most actions you can type [current_date] instead of a date to use the moment the step runs.

How the date time formatter works

  1. Add a step and choose Date/Time Formatter.
  2. Pick an action, for example Convert Timezone.
  3. Map the date into Enter Date and tell the step what it looks like with the format field (From Format, Input Date Format or Date Format).
  4. Choose the output format and any other options, then test the step.
FlowMattic Date/Time Formatter step with the Convert Timezone action, showing Enter Date, Input Date Format, Date Output Format, To Time Zone and From Time Zone.
The Convert Timezone action turning a UTC order time into London time in a readable format.

Choosing formats

Every format field is a list of ready-made formats, each shown with an example: YYYY-MM-DD (2025-01-22), DD/MM/YYYY (22/01/2025), MMMM DD, YYYY h:mm a, ISO-style formats with a time zone offset, and Unix timestamps in seconds, milliseconds or microseconds. WordPress Default uses your site’s date and time settings. Custom opens a field where you type any PHP date format, such as l, j F Y.

The thirteen actions

ActionMain fieldsWhat it returns
Add/Subtract TimeEnter Date, Expression, From Format, To Formatoutput: the shifted date
Modify Current DateDate Output Format, Time Zone, Operation, Time Unit, Time Unit Valueoutput: now, plus or minus days, hours or minutes
Compare Two DatesEnter Start Date, Enter End Date, Start and End Date Formatsdifference, years, months, days, hours, minutes, dates_swapped, same_dates
Modify Date FormatEnter Date, From Format, To Formatoutput: the same date in a new format
Calculate AgeEnter Date of Birth, Date Formatyears, months, days, hours, age, since
Convert TimezoneEnter Date, Input Date Format, From Time Zone, To Time Zone, Date Output Formatoutput in the target time zone
Parse DateEnter Date, Date FormatYear, month, month name, day, weekday, hour, minute, week of year, quarter, timestamp, leap year and more
Check Date ConditionEnter Date, Date Format, Condition, Compare Dateresult: yes or no
Get Relative DateEnter Date, Date Formatrelative, such as “2 days ago”, “in 3 hours” or “yesterday”
Date to Unix TimestampEnter Date, Date Format, Output Unittimestamp in seconds, milliseconds or microseconds
Unix Timestamp to DateUnix Timestamp, Input Unit, Output Date Formatdate
Get Holiday DateSelect Holiday, Year, Output Date Formatdate of the holiday that year
Get Recurring DateOccurrence, Day of Week, Mode, Month, Year or From Datedate, relative, days_until, is_upcoming, month, year

Expressions, conditions and recurring dates

  • Expression in Add/Subtract Time takes plain relative phrases: +8 hours 1 minute, +1 month -2 days or -1 day +8 hours.
  • Condition in Check Date Condition offers Is in the Past, Is in the Future, Is Today, Is Weekend, Is Weekday, Is Before, Is After and Is in Range. The last three use Compare Date; Is in Range checks whether the date falls between today and the compare date.
  • Get Holiday Date knows twelve days: New Year’s Day, Valentine’s Day, Easter Sunday, Good Friday, Independence Day (US), Halloween, Thanksgiving (US), Black Friday, Christmas Eve, Christmas Day, Boxing Day and New Year’s Eve.
  • Get Recurring Date finds dates such as “second Tuesday” or “last Friday”. Occurrence is First, Second, Third, Fourth or Last. Mode is Specific Date (a given month and year), Next Occurrence (from today) or From Date (from a date you supply).

Use cases

Reminders the day before a booking

A salon subtracts one day from each appointment time, then waits until that moment to send the reminder, so Yuki Tanaka hears from them 24 hours ahead.

Flow: FlowMattic Bookings New Booking → Add/Subtract Time (-1 day) → Delay Until → Send Email

Order times in the customer’s time zone

Acme’s store runs on UTC but its customers are in London. Convert Timezone turns the order time into local time and a friendly format before the confirmation email goes out.

Flow: WooCommerce New Order Created → Convert Timezone → Send Email

Trial end dates for new SaaS accounts

Every signup gets a 14-day trial. Add/Subtract Time with +14 days on [current_date] calculates the end date, which is stored with the account for the follow-up emails.

Flow: Webhook (signup) → Add/Subtract Time → WP Tables New Record

Flag support tickets older than a day

A helpdesk sends each ticket’s creation time. Compare Two Dates against [current_date] gives the age in days and hours, and a Router escalates anything waiting too long.

Flow: Webhook (ticket) → Compare Two Dates → Router → Slack Send Channel Message

Monthly client reports on the first Monday

An agency’s reports go out on the first Monday of each month. A weekly schedule fires every Monday, Parse Date reads today’s day of the month, and a Filter lets the run continue only when it is 7 or lower.

Flow: Schedule Every Week (Monday) → Parse Date ([current_date]) → Filter → API by FlowMattic GET → Send Email

Black Friday countdown emails

A marketing team wants the early-access email to go out one week before Black Friday, every year, with no date typed by hand. A daily run finds this year’s Black Friday, subtracts seven days and checks whether that date is today.

Flow: Schedule Every Day → Get Holiday Date (Black Friday) → Add/Subtract Time (-7 days) → Check Date Condition (Is Today) → Filter → Send Email

Readable dates from API timestamps

Many APIs return Unix timestamps in milliseconds. Unix Timestamp to Date with Input Unit set to Milliseconds turns them into dates people can read before they land in a sheet or an AI summary.

Flow: API by FlowMattic GET → Unix Timestamp to Date → Google Sheets Add New Row

Tips and gotchas

  • The input format must match. From Format describes the date you send in, not the one you want out. Modify Date Format forgives one common slip, a two-digit year where you chose four or the reverse.
  • Pick named time zones. Choose a city such as Europe/London in the time zone lists. Manual UTC offsets from the list may not be accepted, and named zones follow daylight-saving changes.
  • “Today” starts at midnight. Is in the Past and Is in the Future compare with the start of today, so a time earlier today counts as in the future. Use Is Today for today.
  • Invalid formats can pass quietly. Compare Two Dates and Calculate Age return a message such as “Invalid date format for start date” without failing the step, so check the output while testing.
  • Where [current_date] works. Add/Subtract Time, Modify Date Format, Convert Timezone, Parse Date, Date to Unix Timestamp, and the start date of Compare Two Dates. Check Date Condition, Get Relative Date and Calculate Age need a real date.
  • Next Occurrence skips today. Get Recurring Date in Next Occurrence or From Date mode looks for a date after the start, so when today is the match it returns next month’s date.
  • Get Recurring Date checks month numbers. In Specific Date mode, Month must be 1 to 12, or the step stops with an error asking for a valid month.

Related features

FAQ

How do I change a date format in a WordPress workflow?

Add a Date/Time Formatter step with Modify Date Format. Map the date into Enter Date, set From Format to match it, and choose a To Format from the list or Custom for your own PHP format.

Can I convert a date between time zones?

Yes. Convert Timezone takes the date, its input format, a From Time Zone and a To Time Zone, and returns the converted date in the output format you choose.

How do I add days to a date?

Use Add/Subtract Time with an Expression such as +7 days, or -1 day +8 hours to combine units. Use [current_date] as the date to count from now.

Does it work with Unix timestamps?

Yes, in both directions. Date to Unix Timestamp and Unix Timestamp to Date support seconds, milliseconds and microseconds, and the format lists include Unix timestamp formats too.

The date time formatter is one of FlowMattic’s built-in data tools, with no per-run cost. See FlowMattic pricing and stop fixing dates by hand.

More from the blog