# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for
Did you mean:
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

I´m trying this..

```table1:
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,
....
```
Tags (4)
1 Solution

Accepted Solutions
Highlighted
MVP

## Re: Join date with time

You mean this:

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

9 Replies
Highlighted
MVP

## Re: Join date with time

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

Highlighted
MVP

## Re: Join date with time

Another solution,

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

Highlighted
MVP

## Re: Join date with time

You mean this:

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

Highlighted
MVP

## Re: Join date with time

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

Highlighted
Not applicable

## Re: Join date with time

What is the diference betweem Date and Date#?

both worhk!

Highlighted
MVP

## Re: Join date with time

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

Highlighted
MVP

I agree.

Highlighted
MVP

## 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)

Highlighted
MVP

Daniel,