Date Format

[Former Member]

Hi Experts,

I have a Date Object in the Universe with the format MM/dd/yyyy.

And i need to create a Prompt where in the user should be asked to select Mon/yyyy like JAN2011.

I tried formatting the object in the Universe by right clicking it and using the format object option, but it does not seem to work in the prompt.

any suggestions?

Thanks

[Former Member · Accepted solution]

You can create a Dimension Object in the Universe and use it in your filter the definition for the object will be as below

=To_Char(@select(date Object),'MON')||To_Char(@select(date Object),'YYYY') this would give you the JAN2011 or FEB2012 based on the date.

Enable the Lov's for the Object and use this object as a query filter

Hope this helps

[CdnConnection · Accepted solution]

I have found users being prompted for for YYYYMM works much better. This way it's easier to cross years.  If you want show Jan 2011 to Dec 2011 in report header after the selection would also be easer to convert.

Ajay Gupta

[Former Member · Accepted solution]

Thanks guys.

Worked it out right on time

[Former Member]

Hi Mohammed,

Create a condition object in the universe and use in report.

TO_DATE(TO_CHAR(DIM_DATE.DATE_DT,'MMM-YYYY'),'MMM-YYYY') = TO_DATE(TO_CHAR(@Prompt('Enter From Date:','D','Time\Date',Mono,Free),'MMM-YYYY'),'MMM-YYYY')

Hope this helps you.

http://scn.sap.com/thread/1917568

And also have a look on this link