How to join fields to one in QV?

[#1]

Hello,

I have date and time data stored in two separate columns in my datasource. In QV I'd like to concatenate them as one timestamp for gettting comparable timestamps. I quess this is possible, but can not figure out how? Definig a new variable maybe?

Thanks!

-dzeidzei

[er_mohit]

are you trying to see date and time in one column??

plz can you clarify it with an example ? whats you want in output

[#3 · Accepted solution]

use this :

date(num(datefieldname) + frac(timestamp(timefieldname, hh:mm:ss')), 'DD/MM/YYYY hh:mm:ss')

Hope it helps.

Regards

[#4]

I have data in database columns like SOME_DATE whichc contaisns values in format dd.mm.yyyy and SOME_TIME with values in format hh:mm:ss. In QV I'd like to have one timestamp style field where thiose tvo separate feils should be joined to one timestamp SOME_TIMESTAMP with values in format dd.mm.yyyy hh:mm.ss

[SunilChauhan]

try this out

date#(somedate&' '&sometime,'dd.mm.yyyy hh:mm:ss')

Hope this helps

[#6]

Thanks qlik_techie. That one did the trick.