Skip to Content
avatar image
Former Member

Date in YYYY/MM/DD format from Time Stamp

Hello All,

I want to have a Date in YYYY/MM/DD format from time stamp in WEBI.

The time stamp dimension is coming as Oct 2 2015 10:09AM .

I want it in 2015/10/02.

I need the day as 02 and not 2.

My final aim is once I have that date in 2015/10/02 format , I need to sort based on date.

Sunny

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 28, 2015 at 12:01 PM

    Hi,

    Right click  on date object in the table->Format Number->date/Time->Click custom->add the yyyy/MM/dd and click OK.

    Amit

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Rupak,

      This might be because your date object is not of date type.

      In this case create a variable and use the 'ToDate' function.

      Let us know if it works.

      Regards,

      Amit

  • avatar image
    Former Member
    Oct 29, 2015 at 05:53 AM

    Hi Rupak,

    There is 2 option..

    !click the Particular column, Format number --> change the format as you like.

    2. Create variable with Format Date

    Add comment
    10|10000 characters needed characters exceeded