Skip to main content
Hi all, I would like to know the day between 2 dates but using the PQL DAYS_BETWEEN it is not working. I need to know how many day passed between a creation of anagrafic vendor (LFA1.ERDAT) and creation PO (EKKO.AEDAT), an between creation of anagrafic vendor (LFA1.ERDAT) and invoice (RBKP.CPUDT). Thank you Laura
Please someone can help me ? I juste need to do date1 - date2 but I do not find the right formulas on PQL. Thanks Laura
Hi Laura, you can get the number of days between two dates with DAYS_BETWEEN. What does not work for you here? Do you get an error message? Or do you get a wrong result? How does the exact query that you tried look like? Best David
Hi, I guess your columns are not in DATE format,if so, you can use TO_TIMESTAMP(Table.StringColumn, YYYYMMDD ) to convert into DATE format or another reason could be No or N-N relationship within object. BR, Amogh
Hi Amogh, My field are DATE and Celonis recognizes them as such. My dates are in a first time :
  • LFA1.ERDAT
  • EKKO.AEDAT
and in a second time :
  • RBKP.CPUDT
  • LFA1.ERDAT
Community Code of ConductAccessibility statement