Date Part or Format Date

[Former Member]

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.

[Former Member · Accepted solution]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

Thanks for reply,

I tried this in report but it didn't work when i try to validate the formula.

thanks

[Former Member]

Hi ,

In Universe try to create an object and instead of MM try to give MON and if doesn't work then use string function

substr(MM,1,3).

Cheers,

Suresh Aluri.

[former_member142702]

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

[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