Shapes

Convert and format values

Format date

Reformats a date or time into the pattern a system expects.

Nodes › DataOpen in Neblex
Good for
Date formats and date arithmetic
Role
Works on the records in a flow
Find it in
Nodes › Data

When to use it

  • A destination needs dates in a specific format.
  • A due date should be calculated, such as 30 days after creation.

Reach for something else when

Map fields and Transform itemsWhen dates are one of many fields you are changing.

Example

Calculate a due date 30 days after the invoice date and write it as day, month and year.

  1. QuickBooks
  2. Format date
  3. Xero

How it works

Settings
Field (a field, or a date call such as add_days(created_at, 30)); Format (strftime) [%Y-%m-%d]; Into field [formatted].
Input
ISO-8601 text or Unix seconds.
More in the guide

Add it to a flow

  1. Open the flow from Build › Workflows.
  2. Open Nodes and find Format date under Data, or search for it. Click it or drag it onto the canvas.
  3. Drag from the previous step's output handle to its input, then open its settings with ✎ Edit.
  4. Run the flow and click the step to see the records it received and produced.

More in Convert and format values

Hash valueCreates a SHA-256 or SHA-512 fingerprint of a field, or a signature with your key.Nodes › DataConvert JSONConverts between records and JSON, CSV or XML text.Nodes › DataCompress (zip)Compresses a text field with gzip and encodes it for transport.Nodes › DataScrape websiteExtracts values from HTML with CSS selectors.Nodes › DataRender markdownTurns Markdown into safe HTML.Nodes › Data