Hi
In my query we have a field PGI Date . The requirement is to convert these dates to display only Month & year in the query output . This requirement is required to be met at query level only without using macros . Can any one suggest me some thing in this regard.
Present Layout:-
Planned pgi Date Sales Organization Distribution Channel
1/2/2009 3035 30
1/2/2009 3035 30
1/2/2009 3035 50
1/2/2009 3035 50
1/2/2009 3035 50
Required Layout
Planned pgi date Sales org Distribution channel
January 2009 3035 30
January 2009 3035 30
January 2009 3035 30
January 2009 3035 30
We have the field 0CALMONTH but that is mapped to 0CALDAY which is very different from PGI date.