Indicator Help - Comparing Two Dates

Sorry, I am know I am missing something simple here. 

I want to count of how many times a project custom date field (Required Date) is less than the Project Due Date. Then display it as an indicator

I am trying to use the function

Sum(if(DDiff([Days in Required Date],[Days in Project Completion Date])<0,1,0))

However I am getting an error back that says 

what am I missing? 

Please and thank you 

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
2 comments

Hey Ped Watt!

I asked about a similar function related to tasks. Ashley helped me out with the formula. This is what she came up with for tasks.

SUM([Task ID], if (SUM(ddiff([Days in Task Completion Date], [Days in Task Due Date]))<01,1,0))

You can view the thread here. I was getting the same syntax error, so I hope this leads you down the right path!

Cheers,

Jessie

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Jessie Stith Thank you for this. I was missing the second Sum, I can see that fixing the property casting issues. 

This is working for me now 

 

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Indicator Help - Comparing Two Dates
[this list is visible for admins and agents only]

Top
Didn’t find what you were looking for? Write new post