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.