on 07-24-2016 11:55 AM
Dear All,
I've got this issue
I have for example a date in number format: 42005 = 01/01/2015
i have in database by number, How can I convert it into date format in webi?
thanks
REgards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Number is the dummy object name which i have considered for numeric values.e.g 42005.
Let say you have object dummy which hold the date numeric values.Then you have to use dummy in the formula.
dates numeric values are started from date 01/01/1900.
like this.
01/01/1900 -1
02/01/1900 -2
In the formula have added the numeric values in the date 01/01/1900 to get the actual date.
if you place =DATEVALUE("01/01/1900") in the excel cell you will get 1.
Hi,
What is your source? How did you arrive with value of 42005? Did you already try to use the FORMATDATE function?
Regards,
Loed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Loed,
that is not possible.
Let me explain you the scenario:
this value is coming up from BPC Cube, the planning Date is inserted in number format in kf.
so, I need to convert it back in WeBI.
got it?
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.