Datefield

[woody1982]

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

[woody1982]

Sorry, I'm still an absolute beginner 🙂 I can't understand that

[steeefan]

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:

1. On the right under "Data connections", select "Purchase:DataFiles"
2. In there, select "0010_QVD_Raw_Z_ERP_NEW_AUSP.qvd"
3. Click "Select"
4. In the preview window, locate the column ATFLV and check it the format is the same as the one you specified earlier, i.e. 2.0230502000000000000E+007, or if its different.

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.

[woody1982 · Accepted solution]

Now we have the solution:

Date(Date#(num(num(replace([ATFLV],'.',','),'(dez)'),'00000000'),'YYYYMMDD'))

Thanks all for the help!