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

Date Part or Format Date

Hi,

I have a datetime column in the universe. The format of the date is "mm/dd/yyyy hh:mm:ss

when users run report they only want to see the format as MON-YYYY.

what syntax shall I use can anybody help.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 26, 2009 at 09:24 AM

    Hi ,

    If date column is a object in a report then right click on that column -> goto object properties -> date & time -> give ur requiredformat i.e Mon/YYYY -> save -> ok.

    Then that column will be displayed as defined by you.

    Cheers,

    Suresh Aluri.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 05, 2009 at 07:30 AM

    Hi,

    what kind of data source do you use in your universe? Which kind of BOBJ report tool do you create your reports with?

    Regards,

    Stratos

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Thanks for the reply,

      I am using sql server 2005 database.

      and Webi Reporting tool.

      I have date column in universe table : 4/1/07 12:00 AM (format)

      when I drag it on to my report i get only 4/1/07 (without time) . I have to format the column to see the time.

      But in few of my report I don't need time and day.

      I only need Month & date ,

      In universe I created the object with " datename(MM,START_DATETIME)' - 'datename(year,START_DATETIME) and its giving full month name.

      I can do the format at report level , but its showing full name of month

      (like January, February etc) I just want to see 3 character for month

      the format should be JUN-2009

      Thanks for help

  • author's profile photo Former Member
    Former Member
    Posted on Jun 05, 2009 at 08:42 AM

    Hello,

    You may create a variable with the following formula..i am assuming date field is a character/dimension.

    =left(date,2)&'-'&substr(date,7,4)

    Thanks and Regards

    Priyanka

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 25, 2009 at 07:21 PM

    Right-click on the object in Designer and choose "Object Format"

    In the category section, choose 'Date/Time'

    In the Properties box at the bottom, type:

    Mmm-yyyy

    Click OK. Save and export universe.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 26, 2009 at 09:24 AM

    Hi ,

    If date column is a object in a report then right click on that column -> goto object properties -> date & time -> give ur requiredformat i.e Mon/YYYY -> save -> ok.

    Then that column will be displayed as defined by you.

    Cheers,

    Suresh Aluri.

    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.