Date in YYYY/MM/DD format from Time Stamp
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.
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.