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

Formatting a Date dimension

Can you change the format of a date dimension. I have a date coming in from my data source in the mm/dd/yyyy format and I need it to be mm/yy. I tried FormatDate function but was not successful. Any suggestions?

Susan

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Sep 19, 2014 at 06:39 PM

    Is your date dimension actually a date data type or is it string data type? Click and hover over the date object in the Available Objects pane to find out.

    Here some links about converting dates in string data types to actual dates and the numerous ways to format a date.

    How to convert a string prompt into a date in WebIntelligence | Business Objects Blog

    Web Intelligence Date Formats | Business Objects Blog

    Hope this helps,

    Noel


    pastedImage_2.png (74.6 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 19, 2014 at 06:08 PM

    If FormatDate is not working then below is the workaround i could suggest.

    a1=FormatDate([Date Obejcts];"dd/mm/yy")// This will bring date in 10/03/14

    a2=Right([a1];4;lenth([a1]))// This will extract mm/yy i.e 03/14

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 19, 2014 at 08:47 PM

    HI


    Please try below..

    =FormatDate(ToDate(YOUR DARE OBJECT);"MM/dd/yyyy HH:mm:ss A");"MM'-'yy")

    =FormatDate(ToDate(YOUR DARE OBJECT);"MM/dd/yyyy HH:mm:ss A");"MM'-'yy'")

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you for your reply. I think this is a good solution. Here's what happened:

      In my report I pulled in my date object and then used the formula editor and typed in:

      =FormatDate(ToDate([Maturity Date];"MM/DD/YYYY HH:mm:ss A");"MM'/'YY")

      I got #Error in my data column. Any ideas?

      Susan

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2014 at 09:55 AM

    Hi Susam,

    If you work with a universe and you use a DATE object.

    You can :

    1/ Open your universe in designer

    2/ Click right on DATE object

    3/ Go to Object format => date : here you can specify date format that you like.

    I hope this can help

    Kind Regards,

    Ameni

    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.