Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like to analyse the ATFLV field from the SAP table AUSP.
However, the date entered is in the format "2.0230502000000000000E+007".
How can I convert this into a correct date?
Thank you very much
Sorry, I'm still an absolute beginner 🙂 I can't understand that
In the QS data load editor, navigate to your library, then open it and select the QVD file you want to get the data from:
In my screenshot from yesterday, I have the data load preview on the left and the QVD opened in an external QVD viewer application on the right:
If the format in the preview window does not match the one you specified, my parsing script will not work and needs to be adapted.
Now we have the solution:
Date(Date#(num(num(replace([ATFLV],'.',','),'(dez)'),'00000000'),'YYYYMMDD'))
Thanks all for the help!