OBIEE 12c Prompt Format change

7688438

HI, i would like to convert below input prompt format to output format. Prompt Input format: snap_shot_date_id-20190731 Output should be: 07312019 Below is the SQL to convert but how to do it in OBIEE Logical sql: TO_CHAR(to_date(snapshot_date_id,'YYYYMMDD'),'MMDDYYYY') Thanks, John

Gianni Ceresa

Double post with OBIEE 12c Prompt Format change , close one of the two to not have 2 threads which will end up unfollowed (as you also hardly close threads).