Extracting month from date field issues

Mon, 04 Oct 2010 10:53:14 GMT

Hi,

I have a perfectly working date field and I have created a second field to pull the month from it so i can start to build summaries for months using the below code.


[TicketHeader.Document Date],
Date([TicketHeader.Document Date],'MMM') as [TicketHeader.Document Month],

This produces the month as expected for each row however when creating graphs (I.e. a graph with have 30/31 duplicate bars for each month) or clicking on the month within this data it still relates to the day rather than the month. Is there anyway to fully extract the month from the date and loose the relationship with the orignal data?

Thanks

Extracting month from date field issues

renjithpl — Mon, 04 Oct 2010 10:58:15 GMT

Try

Month ([TicketHeader.Document Date]) as [TicketHeader.Document Month],

Extracting month from date field issues

Mon, 04 Oct 2010 11:10:46 GMT

Brillaint, now works perfectly.

Many Thanks

topic Extracting month from date field issues in QlikView

Extracting month from date field issues

Extracting month from date field issues

Extracting month from date field issues