You need to sign in to do that
Don't have an account?
Glenn Nyhan 91
How to Calculate Number of Days Between Two Dates
I am trying to calculate the number of days between two date fields but my formula is not working and I can't figure out why. I have a field called Completion_Photos_Upload_Date__c and another called Completion_report_due__c. and a formula field called Completion_Photo_Timing which should calculate the number of days between the dates. Example: one record has a Completion Photos Upload Date of 5/28/2019 and a Finished School Photos Due date of 5/12/2019 which is 16 days. Right now with this formula: DATEVALUE(Completion_Photos_Upload_Date__c )- Completion_report_due__c only shows 9 days. Not sure what's wrong with this formula. There are no syntax errors but 9 days is not the correct answer. Any help fixing would be appreciated.
Make sure you follow these steps:
1. select 'formula field'.
2. then select 'number'.
3.by using insert fields add (Completion_Photos_Upload_Date__c - Completion_report_due__c).
this should work properly because i just i tried it with sample example.
All Answers
Try writing it using Insert fields add (Completion_Photos_Upload_Date__c - Completion_report_due__c)
Make sure you follow these steps:
1. select 'formula field'.
2. then select 'number'.
3.by using insert fields add (Completion_Photos_Upload_Date__c - Completion_report_due__c).
this should work properly because i just i tried it with sample example.