Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Former Member replied

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

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question