on 10-28-2015 11:48 AM
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
Hi,
Right click on date object in the table->Format Number->date/Time->Click custom->add the yyyy/MM/dd and click OK.
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rupak,
There is 2 option..
!click the Particular column, Format number --> change the format as you like.
2. Create variable with Format Date
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.