Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Join date with time

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

Captura.PNG

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,

....

1 Solution

Accepted Solutions

Re: Join date with time

You mean this:

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

9 Replies

Re: Join date with time

How about this:

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

Re: Join date with time

Another solution,

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

Re: Join date with time

You mean this:

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

Re: Join date with time

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

Not applicable

Re: Join date with time

What is the diference betweem Date and Date#?

both worhk!

Re: Join date with time

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

Re: Join date with time

I agree.

Re: Join date with time

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)

Re: Join date with time

Daniel,

Below link might be helpful for better understanding.

The Date Function