topic Re: Timestamp format in QlikView

Timestamp format

datanibbler — Tue, 11 Feb 2014 12:17:59 GMT

Hi,

I have a syntax question which I cannot find the answer to in the help_file:

=> I have a field that comes out of the database as a timestamp in the format 'DD.MM.YYYY hh:mm:ss AM' or 'DD.MM.YYYY hh:mm:ss PM'

=> I know that, generally, to read such a thing I would need the TIMESTAMP# function

=> The question is: How do I specify the 'AM/ PM' as a parameter to this function?

(the outcome I need is just a date, no time)

Thanks a lot!

Best regards,

DataNibbler

Re: Timestamp format

luis_pimentel — Tue, 11 Feb 2014 12:20:07 GMT

If you just need the date, then use Date() or Date#() functions, and forget about the time format.

Hope that helps.

Luis.

Re: Timestamp format

datanibbler — Tue, 11 Feb 2014 12:32:41 GMT

Hi Luis,

that works like a charm! Thank you!

Now I hope I'm going to get my head around what's going wrong - this was just the first step. Anyway, the longest voyage always begins with the first step 😉

Thanks!

Best regards,

DataNibbler