You need to sign in to do that
Don't have an account?
mac_046
Calculating number of days between two dates.....
Hello Everyone,
I have a picklist field with "submitted" and "approved" values. I need to calculate the number of days between the two dates i:e (the date that record was submitted and date that record was approved). Can anyone tell mehow to achieve this requirement.
Thanks in advance
Hi Mac,
Add new formula field and use below foluma to calculate the same.
Regards,
Kamlesh
Hello,
I guess you have two fields to capture those dates. Then simply create a formula field and calculate the difference:
FYI - In additional to workflows the Apex Date Object has fields for performing this functionality.
The Date object has methods to calculate the number of days between two dates.
http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_methods_system_date.htm?SearchType=Stem&Highlight=Date|Dates|dates|date|DATE