formatdatetime - Format Date and Time

Formats a given date and time to the specified ouput format.

date
Type
string
Required
required
The date to format. If Formats to test is not provided, your date needs to be in one of the following formats DD.MM.YYYY, DD.MM.YY, DD.MM.YYYY HH:mm, DD.MM.YY HH:mm, MM-DD-YYYY, MM-DD-YYYY HH:mm, MM-DD-YY, MM-DD-YY HH:mm.
Example:
14/08/22
format
Type
string
Required
required
The desired output format.
Example:
DD.MM.YYYY HH:mm
formatsToTest
Type
array<string>
The formats the date can be in.
Example:
[
  "MM/DD/YY",
  "DD/MM/YY",
  "YY/MM/DD",
  "YY.MM.DD HH:mm"
]

Available on

Postman
Make
Zapier
N8N
Airtable
SeaTable
Bubble
Power Automate
Workato
SAP Build