topic Re: Timestamp format in QlikView

Timestamp format

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi everybody,

I can't solve my problem with a timestamp. Above you can find my table. The numers are formated as "integer". There you can see that the second column ist not formated in the right way, so I can't calculate the duration.

The script to format the second column is:

timestamp#(Aufnahme,'DD.MM.YYYY') as Aufnahme_sAufn,

ut it seems to be wrong. Why?

How can I format my second date in the correct way?

Re: Timestamp format

sunny_talwar — Tue, 12 Sep 2017 13:08:29 GMT

Try this

Date(Floor(TimeStamp#(Aufnahme,'DD.MM.YYYY hh:mm'))) as Aufnahme_sAufn,

Or this

TimeStamp#(Aufnahme,'DD.MM.YYYY hh:mm') as Aufnahme_sAufn,

Re: Timestamp format

prieper — Tue, 12 Sep 2017 13:10:24 GMT

timestamp# reads a given string in the format specified incl the delimiters, so should be

timestamp#(Aufnahme, 'DD.MM.YYYY hh:mm').

This usually should end as a decimula number eg 42950.15.

In order display this as a timestamp you need to enclose this function with the timestamp-function:

timestamp(timestamp#(Aufnahme, 'DD.MM.YYYY hh:mm')) - this may display in the current timestamp settings

timestamp(timestamp#(Aufnahme, 'DD.MM.YYYY hh:mm'), 'DD.MMM.YY hh:mm:ss') - to use any format of your own

Re: Timestamp format

Kushal_Chawda — Tue, 12 Sep 2017 13:18:52 GMT

Your Date is in text format. You can do something like below

In your script, main tab, change below set variable

SET TimestampFormat='DD.MM.YYYY hh:mm';

then use below

date(floor(Aufnahme),'DD.MM.YYYY') as Aufnahme_sAufn,

Re: Timestamp format

Anonymous — Wed, 13 Sep 2017 06:34:33 GMT

timestamp#(Aufnahme, 'DD.MM.YYYY hh:mm' is not working, but the other two Versions!

Thankx!!!

Re: Timestamp format

Anonymous — Wed, 13 Sep 2017 06:36:38 GMT

Correct! This works, too!

Thank you!