QlikView App Dev

[andy_smith2005]

I have a series of text files delimited by white space something like this:

16/01/15 20:45:56

16/01/15 21:50:13

I want to join the two fields together to create a timestamp field from which I can build an incremental load strategy/script. I have tried various things using date,num,timestamp,timestamp#,makedate#floor and the most I achieve is either a string of data which qlikview will only recognise as a string and not a timestamp, or a number which Qlikview doesnt recognise as a date.

Anyone got any ideas??

[jfadderholdt]

Oh Nitesh,

Did that ever help. You just solved what my reading all morning did not!! 

Thanks,