I'm trying to concatenate a field time to a filed date, but I have a liatle problems.
the result is wrong and weird!
this is the result...
Fecha is Date,
Hora is Time and
FechaHora should be the result
I´m trying this..
Date(Fecha,'DD/MM/YYYY') AS Fecha,
time(Hora,'hh:mm:ss TT') AS Hora,
Date(Date(Fecha,'DD/MM/YYYY') + time(Hora,'hh:mm:ss TT'),'DD/MM/YYYY hh:mm:ss TT') AS FechaHora,
Date is formatting function, where as Date# is interprestation function which helps QlikView understand date in case it is not in a regular format (format described in the environmental variables)