Concatenate dates From different source

[HamdiGA]

Hello,
I am trying to concatenate two tables from the différent source (logFile and database) basing on the date filed.
But the problem is that Qlik displays only the date of the first table and convert to a number the second date filed.

[Almen]

Have you tried to transform the fields in your script?

Like

Table1:
LOAD
Date(Table1.Date) as Date,
Time(Table1.Date) as Time,
...
...
From YourSource1;

Table2:
LOAD
Date(Table2.Date) as Date,
Time(Table2.Date) as Time,
...
...
From YourSource2;