- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Date in expression
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
- Tags:
- date expressions
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)