Timestamp field

[#1]

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

[jonathandienst · Accepted solution]

Hi

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