Issue with date?

[Anonymous]

I have dates in text format . Field name is ProjectMonth with values starting Dec-2015 till Nov-2015.

I want to plot a graph that shows the sum of efforts for the months less than the current month. Hence when I try to put an expression as monthname(date#(ProjectMonth,'MM-YYYY'))<=monthname(today()) to calculate the effort for the months less than the current month I am not getting values..Cell values appear blank.

can you anybody please let me know what is going wrong in my expression?

thanks

[tamilarasu · Accepted solution]

Hi Sanjyot,

Use proper date function. It should be

=monthname(date#(ProjectMonth,'MMM-YYYY'))<=monthname(today())

[Anonymous]

You can use sth like this:

=sum({<ProjectMonth={'>=$(=date(monthname(ProjectMonth),'MM-YYYY')'<=date(monthname(today()),'MM-YYYY') }>} Effort)

[Anonymous]

or simply:

=sum({<ProjectMonth={'<=date(monthname(today()),'MM-YYYY') }>} Effort)