Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
kamala swarnalathakamala swarnalatha 

Trailhead challenge not completed on Sugesstion Box app project.

Challenge Not yet complete... here's what's wrong:  The 'Number of Days Open' formula field did not return the correct number of days. Please recheck the formula.

I have this issue when am going to verify step in trailhead.Project-Build aSuggestion Box App

Thanks in Advance!
Kamala
NagendraNagendra (Salesforce Developers) 
Hi Kamala,

Sorry for this issue you are encountering.

I also got same error. Please change from this formula  
IF(ISBLANK(Implemented_Date__c), TODAY() - DATEVALUE(CreatedDate), Implemented_Date__c - DATEVALUE(CreatedDate))
                                                         to 
IF(ISBLANK(Implemented_Date__c), TODAY() - DATEVALUE(CreatedDate) - 1, Implemented_Date__c - DATEVALUE(CreatedDate) - 1)
I did that because the DATEVALUE function was returning 1 day less.

Hope this helps.

Kindly mark this as solved if the reply was helpful so that it gets removed from the unanswered queue which results in helping others who are encountering a similar issue.

Thanks,
Nagendra
 
kamala swarnalathakamala swarnalatha
Hi Nagendra,

Thanks for your reply.I have found out the issue that Time difference between org and the system.

I have changed that it will work for me.

Thanks,
Kamala