topic Create Timestamp Field in QlikView

Create Timestamp Field

Anonymous — Sun, 11 Jul 2010 17:43:36 GMT

I have a DATE field and a separate char field which contains time in hhmiss format. How can I create a timestamp field from these 2 fields?

Thanks,

Dinesh.

Create Timestamp Field

Anonymous — Mon, 12 Jul 2010 18:05:09 GMT

Can anybody help me?

Thanks,

Dinesh.

Create Timestamp Field

pover — Mon, 12 Jul 2010 19:54:45 GMT

Dinesh,

Try timestamp#(DATE & ' ' & CHAR, 'DD/MM/YYYY hhmmss').

I don't know what you date format is so verify that DD/MM/YYYY correspondes with date format in column DATE. Replace CHAR with the name of the column iwth the time.

Regards, Karl