Join date with time

[#1]

Hi everyone,

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..

table1:
LOAD
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,
....

[sunny_talwar]

How about this:

TimeStamp(Fecha + Hora, 'DD/MM/YYYY hh:mm:ss TT') as FechaHora,

[tamilarasu]

Another solution,

Date(Fecha  & ' ' &  Hora, 'DD/MM/YYYY hh:mm:ss TT') as FechaHora;

[sunny_talwar · Accepted solution]

You mean this:

Date#(Fecha  & ' ' &  Hora, 'DD/MM/YYYY hh:mm:ss TT') as FechaHora;

[tamilarasu]

I think interpretation is not needed in this case. I have not checked but it might work (I guess).

[#6]

What is the diference betweem Date and Date#?

both worhk!

[sunny_talwar]

May be you are right, but I would put the interpretation just to be on the safe side

[tamilarasu]

I agree.

[sunny_talwar]

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)

[tamilarasu]

Daniel,

Below link might be helpful for better understanding.

The Date Function