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?>
Tagged:
0