Date in YYYY/MM/DD format from Time Stamp

[former_member228575]

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

[amitrathi239 · Accepted solution]

Hi,

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

Amit

[former_member228575 · Accepted solution]

Hello Amit,

I am not getting the option -Format Number when I right click on the date object in the table.

Sunny

[former_member211423 · Accepted solution]

Hi Rupak,

Use below:

V_Date= FormatDate([Your Date Object];"yyyy/MM/dd")

Regards

Sheetal Sharma

[former_member228575 · Accepted solution]

Hi Sheetal,

Getting the below error

[Former Member · Accepted solution]

Check this

https://service.sap.com/sap/support/notes/0001694041

[former_member220624 · Accepted solution]

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

[Former Member]

Hi Rupak,

There is 2 option..

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

2. Create variable with Format Date