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

Hoe to change the date format

Hi friends,

Hope all are good,

I have one issue in date format. In my database i have the date format like this. yyyy-mm-dd h:mm:ss.0000 like this, it contains all hours and minutes,seconds information. But when i use this date in the webi, it display like this mm-dd-yy, then i changed the format in universe, then it display like this yyyy-mm-dd 00:00:00:.0000, instead of hour miutes seconds it display's only zeros.

The same date i used as a filter in the report as well. is there any way to handle this. Otherwise how can i change the date format.Becoz based on the hour minute second only my client needs to filter the data.

Plz advise me

Thanks lot,

Reagdrs,

-B-

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2008 at 07:20 AM

    you can use this

    in universe

    Object date = convert(datetime,date_submitted,120)as Date

    May be it can help you.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2008 at 07:53 AM

    First in universe designer

    create a object like

    Date = convert(datetime,date_submitted,120)as Date

    use this formula in report designer

    =FormatDate([Date];"dd-mmm-yyyy hh:mm")

    hope it will work

    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.