Skip to Content
0
Former Member
Feb 20, 2009 at 04:23 AM

Converting date field to display only the month & year

876 Views

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.