Categories
- All Categories
- 67 Oracle Analytics News
- 5 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 38 Oracle Analytics Trainings
- 55 Oracle Analytics Data Visualizations
- 1 Oracle Analytics Data Visualizations Challenge
- 2 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
How to use if statement for comparing dates in BIP template
Summary:
How to use if statement for comparing dates in BIP template
Content (please ensure you mask any confidential information):
I have customised the Customer Statement Data Model to show me the apply_date of the payment. Now I wish to show payments only where the apply_date is before the statement_date. I have put in the following conditions to try and achieve this.
<?if:CDC_PAYMENT_AMT=''?>0<?end if?>
<?if:CDC_PAYMENT_AMT!='' and CDC_APPLY_DATE <= STATEMENT_DATE?><?CDC_PAYMENT_AMT?><?end if?>
<?if:CDC_PAYMENT_AMT!='' and CDC_APPLY_DATE > STATEMENT_DATE?>0<?end if?>
All my payment amount are however presenting as null values which is incorrect. There are payments that should appear and some should appear as 0
I have uploaded the rtf and here is snippets of the xml where you can see the statement_date and also the cdc_apply_Date.
So in this particular example the apply date is before statement date therefore the payment_amount should pull through as 4664.40 but it is pulling as null value
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):