Convert text to date-time

Description

Converts text to date and time by format

Input Ports

Name	dataType	sourceType	required	description
Convert Type	text	manual-only	true	The format the output should be and the input type it expects determine the convert type
Encoded Date	boolean	manual-only	true	Set this to true if the date is encoded in 1904 Date System. 1904 is the default format for Excel in MacOS
Date format	text	link-manual	true	The format the date should be after being converted. Read more on date formats
Text value	text	link-manual	true	The text value that will be converted to a date

Scenarios

• The user wants to convert a Text value to a date in the following format DD-MM-YYYY HH:mm:ss
• The user wants to convert a Text value to a date in the following format DD-MM-YYYY
• The user wants to get a formatted date in the following format DD-MM-YYYY from an excel date number 34519
• The user wants to convert a formatted date 04-07-1994 to an excel date number

Use case

Inputs

• Convert Type: From Text
• Date Format: YYYY-MM-DD HH:mm:ss a
• Text value: 05/02/2001 12:34:55

Experienced tips

• If the Date format is empty, the process will continue and use the default format of YYYY-MM-DD HH:mm:ss a
• If the Text value is empty, the process will continue and provide you with the following result Invalid Date

Output

Search Tags

convert text to formatted date-time convert excel date to formatted date-time convert formatted date-time to excel date number