Hi team,
This is related to PQL function CURRENCY_CONVERT_SAP.
I want to know how this field GDATU from TCURR table is converted to date once it is in string in celonis.
Page 1 / 1
The field is in inverted date format: the 9er complement of each digit is stored instead of YYYYMMDD. To convert it to YYYYMMD it needs to be subtracted from 99999999
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.