How to make custom date in OBIEE

[ariel20029]

Hi, I would like to customize the date format to be YYYY-MO, Can you please let me know what it should look like. Right now it says
[FTM:DATESHORT]

thank you so much.
Sharon

 

[Matt Allington]

Well this is not an official date format, but a text representation. So you can create a year column from your date using the year function. Then create a month column, then finally concatenate them together with a - in between.

 

[ariel20029]

Thank you