Concatenate Date and Time Fields in ISO 8601 Format
Created By: Igelu-Eluna Analytics
Created on: 4/29/2020
Formula
TO_DATETIME(CAST("Loan Date"."Loan Date" as CHAR)||' '||CAST("Loan Date"."Loan Time" as CHAR), 'dd-mon-yy hh:mi:ss')
Column Properties > Data Format = Custom, and
yyyy/MM/ddTHH:mm:ssZ
IGeLU-ELUNA Analytics Working Group / Analytics Working Group Listserv