Help with a Formula Converting Two Date Times Giving Number of Days
Im trying to figure out how to use that time stamp to determine how many days from that stamp it has been. I created a field called Days_Lead_Status_Unchanged__c (Number) and used this formula, but I am not seeing anything change. Any ideas or help would be greatly appreciated.
DATEVALUE(Lead_Status_Time_Stamp__c) - TODAY ()
That formula should be fine - I use it in my org all the time.
You may want to switch em around, so your dates are positive:
Today() - DATEVALUE(Lead_Status_Time_Stamp__c)
Can you create a Report or a List View that displays all of the Fields in your Formula and the Formula results side-by-side and post a screenshot? If you're getting a bad or unexpected result instead of a Syntax Error, it's gonna make troubleshooting the Formula much easier if we can see both the Input values and the Output results side-by-side.
Tips & Tricks: Measure twice and cut once with Formula QC List Views and Reports
https://success.salesforce.com/answers?id=9063000000046BfAAI (https://success.salesforce.com/answers?id=9063000000046BfAAI )
Workflow #1: Update Lead Status TIme Stamp
Rule Criteria: (Lead: Lead Status EQUALS New) OR (Lead: Lead Status EQUALS Assigned) OR (Lead: Lead Status EQUALS In progress)
Field Update: NOW()
Workflow #2: Update Days Lead Status Unchanged
Rule Criteria: NOT(ISBLANK( Lead_Status_Time_Stamp__c))
Field Update: (TODAY() - DATEVALUE(Lead_Status_Time_Stamp__c))