Difference between 2 dates - BI Publisher
I'm trying to get the difference between 2 dates in BIP data model.
The difference should present number of days between cmp.DATE_FROM and cmp.LAST_UPDATE_DATE.
Currently I receive results presenting days and hours like below:
Could you please advise how to update my query to receive the number of days only?
I will be grateful for your help.
Please find my full query attached.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):