Favoritesurabhi L (EPCET) asked in #Trailhead ChallengesMay 8, 2020, 8:10 AMThe 'Number of Days Open' formula field did not return the correct number of days. Please recheck the formula.6 answersSortSort by DateSort by Most HelpfulSort by DateLoad more comments...Federico Solis (C)Jun 14, 2024, 7:42 AMYou must adjust your personal time zone or use the formula below instead. IF(ISBLANK(Implemented_Date__c), TODAY() - DATEVALUE(CreatedDate) - 1, Implemented_Date__c - DATEVALUE(CreatedDate) - 1)Add a commentWrite an answer...BoldItalicUnderlineStrikethroughBulleted ListNumbered ListAdd linkCode blockInsert imageAttach filesLink URLCancelSave0/9000Reply
Federico Solis (C)Jun 14, 2024, 7:42 AMYou must adjust your personal time zone or use the formula below instead. IF(ISBLANK(Implemented_Date__c), TODAY() - DATEVALUE(CreatedDate) - 1, Implemented_Date__c - DATEVALUE(CreatedDate) - 1)