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
Page 1 / 1
Please someone can help me ?
I juste need to do date1 - date2 but I do not find the right formulas on PQL.
Thanks
Laura
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
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
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 :
and in a second time :
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.