When you have a date column and you want to sort it as Descending when picked in Answers but automatically from rpd.
1. Insert a new column in the BM Layer in Rpd using calculation below
-(1) * CAST ( EVALUATE('TO_CHAR(%1,%2)' AS CHARACTER ( 30 ), yourcolumn, 'YYYYMMDD') AS INTEGER )
yourcolumn is the column that you want to sort.
2. Once created goto the original column yourcolumn and set the sort order to the column you just created above.
Thats Its ...
1. Insert a new column in the BM Layer in Rpd using calculation below
-(1) * CAST ( EVALUATE('TO_CHAR(%1,%2)' AS CHARACTER ( 30 ), yourcolumn, 'YYYYMMDD') AS INTEGER )
yourcolumn is the column that you want to sort.
2. Once created goto the original column yourcolumn and set the sort order to the column you just created above.
Thats Its ...
Note: only a member of this blog may post a comment.