Creating a 12 month calendar from a list of dates

[knightwriter]

I originally had an issue with single dates to a month but next problem!

Now you can see I have a list of one month many times. I want my end result to be a calendar, ie select July and my stats now show all July as a whole month and not just one day.

[prieper]

Looks as if you have only formatted the date.

Please use a function like

MONTHNAME(MyDate)     AS MyMonth

This field will show each occurance only once, thus being selectable

HTH Peter

[PrashantSangle]

Hi

try with

Date(MonthStart(DateField,'MMMM'))

or

MonthName(Monthstart(DateField))

Regards

[knightwriter]

Hi Peter / max,

That worked a charm. I now have the month and the year in the same text box, I would like this separated and to lose the year. See image below for expression

[prieper]

Have a look into the DATE-functions in the OL-Help:

MONTH([Activity.Completed Date])     AS Month

YEAR([Activity.Completed Date])        AS Year

should deliver the results

Peter

[knightwriter]

Hi Peter,

Many thanks for reply. I will certainly check it out. Is it possible to list the months as Jan Feb Mar instead of alphabetically?

Thanks again

[PrashantSangle]

Hi,

Yes it is possible,

Go to property->sort->

try with Numeric->Ascending

or

with Expression->match(FieldName,'Jan','Feb','Mar')

Regards

[knightwriter]

Lads, thank you so much.

I have a whole bunch of years list and only want 2014,2015 & 2016. How do I exlcude the others?

[PrashantSangle · Accepted solution]

Hi,

What is your expresssion for Year??

if you are using YEAR([Activity.Completed Date])

then write if(match(YEAR([Activity.Completed Date]),'2014','2015','2016'),Year)

Regards

[knightwriter]

Thank you.