how to change 01/01/1970 format to 1970 / 01 this format create prompt in obiee 11g

User_HQ9TE

how to change 01/01/1970 format to 1970 / 01 this format create prompt using between in obiee 11g.

could you please guide me anyone

thanks.

Sumanth V -Oracle

@User_HQ9TE - This is not possible at the prompt level, but can be achieved at column level only using column properties in criteria. Similar discussion can be found in below community thread, kindly refer and let us know if it helps.

https://community.oracle.com/products/oracleanalytics/discussion/5970/obiee-12c-dashboard-date-prompt-how-to-change-date-display-format