topic Re: Join date with time in QlikView

Join date with time

Tue, 28 Jun 2016 15:09:09 GMT

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

Re: Join date with time

sunny_talwar — Tue, 28 Jun 2016 15:30:40 GMT

How about this:

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

Re: Join date with time

tamilarasu — Tue, 28 Jun 2016 15:54:57 GMT

Another solution,

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

Re: Join date with time

sunny_talwar — Tue, 28 Jun 2016 15:57:32 GMT

You mean this:

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

Re: Join date with time

tamilarasu — Tue, 28 Jun 2016 16:01:52 GMT

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

Re: Join date with time

Tue, 28 Jun 2016 16:02:39 GMT

What is the diference betweem Date and Date#?

both worhk!

Re: Join date with time

sunny_talwar — Tue, 28 Jun 2016 16:03:16 GMT

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

Re: Join date with time

tamilarasu — Tue, 28 Jun 2016 16:06:12 GMT

I agree.

Re: Join date with time

sunny_talwar — Tue, 28 Jun 2016 16:07:23 GMT

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

tamilarasu — Tue, 28 Jun 2016 16:10:12 GMT

Daniel,

Below link might be helpful for better understanding.

The Date Function