Skip to Content
author's profile photo Former Member
Former Member

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

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Posted on Jan 09, 2014 at 01:22 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2014 at 01:29 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2014 at 07:08 PM

    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..

    How to use formulae to change date and time formats in WebIntelligence

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 09, 2014 at 05:09 AM

    =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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2014 at 01:34 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.