Skip to main content
Question

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.

  • July 16, 2024
  • 1 reply
  • 3 views

gauri.pai11
Level 2
Forum|alt.badge.img+3
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.

rita.kiss12
Level 4
Forum|alt.badge.img

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