Date in expression

[#1]

Hi, I would to create two KPI whereby count the number of project is in Start Phase as at today and as at 1/12/(This year)

The following expression is what i try to write but fail:

Count({$<Phase={Start}, ([Start Date] <= {'Today()'}, ([End Date] <= {'Today()'} )>}Phase)

Count({$<Phase={Start}, ([Start Date] <= {'MakeDate(Year(Today()),12,1)'}, ([End Date] <={'MakeDate(Year(Today()),12,1)'})>}Phase)

Project	Phase	Start Date	End Date
Project 1	Tender	1/6/2015	30/6/2016
Project 1	Start	1/7/2016	1/2/2017
Project 2	Tender	1/3/2015	30/8/2015
Project 2	Start	1/9/2015	3/10/2016
Project 3	Tender	1/8/2016	1/9/2017

Thanks in advance

[swuehl]

Try

Count(

{$<Phase={Start}, [Start Date] = {"<=$(=Date(Today(),'D/M/YYYY'))"}, [End Date] = {"<=$(=Date(Today(),'D/M/YYYY'))"}) >} Phase)

Count(

{$<Phase={Start}, [Start Date] = {"<=$(=Date(MakeDate(Year(Today()),12,1),'D/M/YYYY'))"}, [End Date] = {"<=$(=Date(MakeDate(Year(Today()),12,1),'D/M/YYYY'))"}) >} Phase)

[sunny_talwar · Accepted solution]

May be these:

Count({$<Phase = {Start}, [Start Date] = {"$(='<=' & Date(Today(), 'D/M/YYYY'))"}, [End Date] = {"$(='<=' & Date(Today(), 'D/M/YYYY'))"}>}Phase)

Count({$<Phase = {Start}, [Start Date] = {"$(='<=' & Date(MakeDate(Year(Today()),12,1), 'D/M/YYYY'))"}, [End Date] ={"$(='<=' & Date(MakeDate(Year(Today()),12,1), 'D/M/YYYY'))"}>}Phase)