on 05-07-2009 12:17 PM
Hi all i am getting below problem .. please let me know solution where can i convert char to date
Date is reflected as Characters in BO. Despite changing it at the Universe level (From Character to Date)
User Prompt : Between "Start Month-Yr" and "End Month-Yr"
User Response Start Month-Yr Jan 2005
End Month-Yr Mar 2005
Desired Ouput: Jan 2005 Feb 2005 Mar 2005
Actual Output Jan 2005 Jan 2006 Jan 2007 Jan 2008 ..(Till the data availability for JANu2026.)
Jun 2005 Jun 2006 Jun 2007 Jun 2008 ..(Till the data availability for JUNu2026.)
Jul 2005 Jul 2006 Jul 2007 Jul 2008 ..(Till the data availability for JULu2026.)
Mar 2005 Mar 2006 Mar 2007 Mar 2008
Hi,
This is not a date issue but a problem that the values are sorted alphabetically.
Didier
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
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.