on 09-19-2014 5:36 PM
Can you change the format of a date dimension. I have a date coming in from my data source in the mm/dd/yyyy format and I need it to be mm/yy. I tried FormatDate function but was not successful. Any suggestions?
Susan
Is your date dimension actually a date data type or is it string data type? Click and hover over the date object in the Available Objects pane to find out.
Here some links about converting dates in string data types to actual dates and the numerous ways to format a date.
How to convert a string prompt into a date in WebIntelligence | Business Objects Blog
Web Intelligence Date Formats | Business Objects Blog
Hope this helps,
Noel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If it is a date I think we are all making this more complicated than it needs to be. I think you just need to create a custom format of MM'/'yy. To do that do the following...
You have to be using the Java Applet or Rich Desktop versions of Web Intelligence to be able to create a custom format. Once you have done so it can be used in the HTML version of Web Intelligence; it just can't be created there.
Does that help?
Noel
Hi Susam,
If you work with a universe and you use a DATE object.
You can :
1/ Open your universe in designer
2/ Click right on DATE object
3/ Go to Object format => date : here you can specify date format that you like.
I hope this can help
Kind Regards,
Ameni
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI
Please try below..
=FormatDate(ToDate(YOUR DARE OBJECT);"MM/dd/yyyy HH:mm:ss A");"MM'-'yy")
=FormatDate(ToDate(YOUR DARE OBJECT);"MM/dd/yyyy HH:mm:ss A");"MM'-'yy'")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If FormatDate is not working then below is the workaround i could suggest.
a1=FormatDate([Date Obejcts];"dd/mm/yy")// This will bring date in 10/03/14
a2=Right([a1];4;lenth([a1]))// This will extract mm/yy i.e 03/14
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
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.