Timestamp field

Thu, 19 Jul 2012 10:53:12 GMT

I have the below string as my timestamp when pulled in QV from an SAP system

20111103145103

How can I make this into a meaningful date?

I have used the following but to no avail - date(date#(Timestamp,'DDMMYYY'))

Thanks

Re: Timestamp field

jonathandienst — Thu, 19 Jul 2012 11:08:29 GMT

You are on the right track, but the format string in the date# function must match the data exactly. Assuming the remaining digits represent the time (and I think the date is in YYYYMMDD format):

date(date#(Timestamp, 'YYYYMMDDhhmmss'))

Although this displays the date only, the time part is still part of the value (date() only formats, it does not truncate)

If you want to discard the time part, use:

date(floor(date#(Timestamp, 'YYYYMMDDhhmmss')))

Hope that helps

Jonathan

topic Re: Timestamp field in QlikView

Timestamp field

Re: Timestamp field