Hello,
We have a tranformation where we would like to convert a date from the following format:
"'dd/mm/yyyy' 'hh:mm'" (double quotes are just visual to indicate this is a string)
to date and time separated:
date: dd/mm/yyyy
time: hh:mm
We have already splitted the datetime into date and hour as follows:
set fechaHora = source.result.GetAt(indice).fechaHora
$$$LOGINFO("fechaHora: "_fechaHora)
set fechaHoraSinComillas = $replace(fechaHora,"'","")
$$$LOGINFO("fechaHoraSinComillas: "_fechaHoraSinComillas)
set fecha = $piece(fechaHoraSinComillas," ")
$$$LOGINFO("fecha: "_fecha)
set hora = $piece(fechaHoraSinComillas," ",2)
$$$LOGINFO("hora: "_hora)