CREATEDATETIME Function

Parameters (Date, Time);

Returns: Timestamp;

Function to add a date and time together to create a dateTime (Timestamp)

The first parameter is the date. This should be a source field reference of type 'date' or a string value with the format 'yyyy-MM-dd'

The second parameter is the time. This should be a source field reference of type 'time' or a string value with the format 'HH:mm:ss'

 The examples below show the characters that can be used in the pattern.

Example: 

CREATEDATETIME([date],[time]) where [date] has a value of '1st Jan 2019', [time] has a value of '17:00:00'

Result:

2019-01-01 17:00:00

All times are assumed to be Universal Coordinated Time.