Date Formatter Task¶

Overview¶

The Date Formatter Task reads a date and gives it back in another form: another layout, the day of the week, the week of the month or the month's name — or a number of days later or earlier.

When to use this task:

• Turn a dd/mm/yyyy date into yyyy-mm-dd for another system
• Show a date as "14 September 2026" in a message
• Find the weekday of a date
• Work out a date a number of days from another

Key Features:

• Twelve conversions, chosen from a list
• Reads the common ways a date is written, with or without a time
• Add or subtract days
• Defaults to today when no date is given

Quick Start¶

1. Add the Date Formatter task
2. Choose the Formatter
3. Set Input Date — a date, or a {{variable}} from an earlier task
4. For Add Days / Subtract Days, set Days
5. Test and save

Simple Example:

Formatter:  dd/mm/yyyy → dd Month yyyy
Input Date: {{task_49001_date}}            (28/09/2026)
Output:     {{task_26001_output}} = 28 September 2026

Configuration¶

Builder fields¶

The Field column is the label as it appears in the task builder; Key is the name the value is stored under and referenced by.

Field	Key	Type	Default	Notes
Formatter	formatter	select	date_formatter_1	Options: Date: dd/mm/yyyy → yyyy-mm-dd · Date → Day of Week · Date → Week of Month · dd Month yyyy → dd/mm/yyyy · dd-mm-yyyy → dd/mm/yyyy · yyyy-mm-dd → dd/mm/yyyy · dd/mm/yyyy HHss → yyyy-mm-dd HHssZ · dd/mm/yyyy → Month of Year · dd/mm/yyyy → dd Month yyyy · dd/mm/yyyy → dd Month · Add Days · Subtract Days
Input Date	Text Input	text	–
Days	days	text	–	Only shown when formatter is add_days, subtract_days

Formats¶

Formatter	Example input	Output
Date: dd/mm/yyyy → yyyy-mm-dd	28/09/2026	2026-09-28
Date → Day of Week	28/09/2026	Monday
Date → Week of Month	28/09/2026	5
dd Month yyyy → dd/mm/yyyy	28 September 2026	28/09/2026
dd-mm-yyyy → dd/mm/yyyy	28-09-2026	28/09/2026
yyyy-mm-dd → dd/mm/yyyy	2026-09-28	28/09/2026
dd/mm/yyyy HHss → yyyy-mm-dd HHssZ	28/09/2026 14:30:00	2026-09-28 14:30:00+02:00
dd/mm/yyyy → Month of Year	28/09/2026	September
dd/mm/yyyy → dd Month yyyy	28/09/2026	28 September 2026
dd/mm/yyyy → dd Month	28/09/2026	28 September
Add Days	28/09/2026, Days 7	05/10/2026
Subtract Days	28/09/2026, Days 7	21/09/2026

The name of each format describes its output; the input can be written in any of the ways below.

Dates it reads¶

Each optionally followed by a time (14:30, 14:30:00, a T separator, a trailing Z or +02:00):

• Day first: 28/09/2026, 28-09-2026, 28.09.2026, 8/9/2026
• Year first: 2026-09-28, 2026/09/28 — the shape of every system timestamp in BaseCloud
• Month named: 28 September 2026, 8 Sep 2026

Day first, never month first: 03/04/2026 is 3 April. The written date is the date: a time zone offset is accepted but not converted, so a date never moves across midnight.

Empty input means today.

Real-World Examples¶

Put a readable date into a message¶

Schedule
  └─ Date Formatter   dd/mm/yyyy → dd Month yyyy, input {{current_date}}
      └─ Email        "Your report for {{task_26001_output}}"

Work out a follow-up date¶

Form Submission
  └─ Date Formatter   Add Days, 7
      └─ Workflow Note  due {{task_26001_output}}

Normalise a supplied date before storing it¶

Webhook In
  └─ Date Formatter   Date: dd/mm/yyyy → yyyy-mm-dd
      └─ Edit Client  save {{task_26001_output}} to a custom field

{{task_26001_input}} still holds what arrived, which makes a bad input easy to spot.

Outputs¶

When the task fails¶

The run fails — and the tasks after it do not run — when:

• No format is chosen, or an unknown one is stored
• The input cannot be read as a date — the message lists the shapes it reads
• The date does not exist, such as 31/02/2026 — it is refused, not rolled into March

Troubleshooting¶

Invalid input date format¶

Check the input is one of the shapes above. A US-style 09/28/2026 is not read — dates are day first.

Wrong day or month¶

03/04/2026 is 3 April, not 4 March. If the source writes month first, rearrange it with the Formatter or a Code task first.

Add Days did nothing¶

Set Days to a whole number; an empty or non-numeric value adds 0.

Frequently Asked Questions¶

Can it convert time zones?¶

No. A time zone offset in the input is read and kept as written.

Can it add months, hours or weeks?¶

Only days. For weeks, add 7 × the number of weeks; for anything else, use a Code task.

How do I get today's date?¶

Leave Input Date empty, or use {{current_date}}.

Related Tasks¶

• Timer Trigger - Run a workflow on a timetable
• Date Trigger - Date-based triggers
• Formatter - General text formatting
• Code - Complex date logic
• If Statement - Date comparisons