Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear QlikViewers,
I'm extracting a SAP table (COSP) into my QV application, but I'm having issues with the timestamp field.
It looks something like this: e.g.
27-Jun-2232681748 00:00:00 (value: 7090287940000 from SAP DB) and
26-Sep-2232704445 00:00:00 (value: 7090296230000 from SAP DB)
As you can see the year format is not what I would expect.
Does anyone have any idea how to solve this? Or how to deal with it?
We're using the QV SAP connector.
Try maybe
=Timestamp(MakeDate(1990) + YOURTIMESTAMPFIELD / (10000 *24*60*60) )
Try maybe
=Timestamp(MakeDate(1990) + YOURTIMESTAMPFIELD / (10000 *24*60*60) )
Thanks Swuehl!
This seems to do the trick. However, this only works in a listbox or in the report application itself.
Is there a way so I could get rid of this problem in my transformation step/application? (And don't have to bother about it in all my further applications)
Does this not work also in a QV script LOAD statement, like
LOAD
YOURTIMESTAMPFIELD,
Timestamp(MakeDate(1990) + YOURTIMESTAMPFIELD / (10000 *24*60*60) ) as NEWFIELD,
...
??
You can probably also do the transformation on DB side, depending on your DBMS.
Thanks again Stefan!
Your solution also works in the script... Monday morning... didn't look close enough/paid attention to it...
Sorry!
I don't think I can change this field in the SAP DB (is this what you mean?). I'll do it in my QV app.
Is this date/timestamp issue a known 'problem' with SAP DB by the way?
I'm new to SAP (and getting pretty frustrated with the 'thousands' of tables with unreadable abbreviations).
Does SAP provide some sort of overview or documentation of their tables?
Happened to run into this use-case and deciphered it the following way: