Extracting month from date field issues

[#1]

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

[renjithpl · Accepted solution]

Try

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

[#3]

Brillaint, now works perfectly.

Many Thanks