You need to sign in to do that
Don't have an account?
Glenn Soden 2
Rolling Day Count Calculation until Future Date Entry
Trying to figure out how to count number of days and populate a field for "Date__C" calcualtion. That part is easy. But need it to count until ANOTHER date is entered then stop.
Assuming a workflow rule that can run the "counter" but then how to stop once second date is entered and be calculated upon.
(Date1__C) - TODAY() - this runs and gives a running count (X # of Days in number field) until below happens
(Date1__C) - (Date2__D) which then produces (X # of Days in number field) and stops as the final date has been entered and reached.
Any ideas? And no not going ot get into the weekend days vs week days. Thanks in advance!!
Assuming a workflow rule that can run the "counter" but then how to stop once second date is entered and be calculated upon.
(Date1__C) - TODAY() - this runs and gives a running count (X # of Days in number field) until below happens
(Date1__C) - (Date2__D) which then produces (X # of Days in number field) and stops as the final date has been entered and reached.
Any ideas? And no not going ot get into the weekend days vs week days. Thanks in advance!!
I think this can be achieved by a number formula field itself.
Solution:-
We have two dates
1) Date1__c
2) Date2__c
The formula field
Hope it helps.
RD
All Answers
I think this can be achieved by a number formula field itself.
Solution:-
We have two dates
1) Date1__c
2) Date2__c
The formula field
Hope it helps.
RD
Yup RD - thats what I ended up doing. here is what eneded up working for me below
Data TypeFormula
Decimal Places0
IF(ISBLANK(Submitted__c ),TODAY() - Opportunity__r.CloseDate, Submitted__c - Opportunity__r.CloseDate)