Format Date

Overview

Takes a date represented in any format and reformats it.

Example

For example. Say you have a file that contains dates in the US date format: 11/23/2018. PayGate needs the date in the UK format dd/mm/yyyy. Using the Date Format node you can easily reformat the date into the desired format.

In the above example the date output from the JSON importer provides the date from the file in mm/dd/yyyy format.

This is fed into the ‘Format Date’ node. This node has been configured as follows:

In the Start Format text box you tell Paygate about the format of the string as it enters the Date Format node. In this example the incoming date is in US format and we we tell Paygate about this by entering MM/DD/YYYY

In the ‘End Format’ textbox you tell Paygate how you want the date formatted as it leaves the node.

Template tokens

The template determines the format that the date will be created. This allows you to create a dates such as 23/12/19 or 12/23/2019 or just about any other date or time format you might need.

Tokens are used to represent the part of a date or time. For example, the token YYYY represent a four digit year.

Date Tokens

Time Tokens