Need help with BIP sorting
I am trying to sort a BI report table by a date field coming from Siebel. I have been reading about the different date formats between Siebel and BIP and have already changed the field in the table to read:
<?format-date:psfn:totext(ssCloseDate,"yyyy-MM-dd","MM/dd/yyyy");'SHORT'?>
as opposed to the simple ssCloseDate. My problem is I want the table to sort by this field descending and I cannot figure out how to do this. The following code is still doing a text sort but when I try to change the code from
<?for-each:ssOpportunity?><?sort:ssCloseDate;'descending';data-type='date'?> to <?for-each:ssOpportunity?><?sort:<?format-date:psfn:totext(ssCloseDate,"yyyy-MM-dd","MM/dd/yyyy");'SHORT'?>;'descending';data-type='date'?>, it throws an error saying the syntax is incorrect.