Change mm-dd-yyyy hh:mm:ss to mm-dd-yyyy in user prompt

[Former Member]

Hi All,

In a Prompt I have date values as '02-12-2013 12:00:00', mm-dd-yyyy hh:mm:ss, i need to change the date to mm-dd-yyyy in the prompt.

I dont have acess to universe and i cannot achieve it in universe level, I need to do it in webi level, using R3.1, any help on this would be much appreciated, please suggest me the solution soon..

Thanks in advance.

[Former Member]

Hi Arijit, Its not working, still the prompt window hold the timestamp.. while selecting the value its hsowing 'h:mm:ss'

[Former Member]

Hi,

you mentioned, you don't have universe access so you follow this.

If You have access to edit the SQL, there you can change that user promt wothout timestamp.

Just findout the prompt for that date and changed that format date only instead of date with timestamp. ie. dd/MM/yyyy instead of dd/MM/yyyy hh:mm:ss

Thanks,

Sakthi.

[CdnConnection]

RKP,

        Since you want to use this as a PROMPT within the WebI, It MUST be changed in Universe.  There is nothing you do from WebI that will change format prior to running to the report.

You will need to work with you Universe Designer to change the SQL in the Universe.

Regards,

Ajay

[arijit_das]

=FormatDate([DateObject];"MM-dd-yyyy")

Also you can right click on the date column and change the format.

Again, please search before you post. There are a lot of examples available like this in SCN and other websites.

[Former Member]

Hi All,

Thanks for your post..

I need to do it in a prompt, not in the report, while selecting values in the prompt after i click run query  it should display mm-dd--yyyy instead with timestamp..

morover i cannot do custom query aswell

Thanks for your help

[arijit_das]

That format in prompt changes with preferred viewing locale. Try changing that.

[Former Member]

Try changing the object format from the universe object which is used for the prompt to the desired format..

[Former Member]

This type of questions have been discussed many times. Please search thoroughly before creating a new discussion. Please go through the blog below by Neha which should help..