Relative Date Value (THIS WEEK,NEXT WEEK,LAST WEEK)

Question

I have below filter in List view for my custom object and client's locale is US English. Scheduled Date equals THIS WEEK List view retrieves all records with scheduled date from Sunday to Saturday. Client wants the THIS WEEK filter start from Monday to Sunday. Same issue with Scheduled Date equals NEXT WEEK and Scheduled Date equals LAST WEEK From this link.UK English starts from Monday and ends Sunday.We don't want to change Client Locale to UK English. Any other ways to achieve this without manually editing the filter dates ?

Benjamin Moore · Accepted Answer

That functionality does not exist, but Salesforce is aware that people want it. Based on comments (19 days ago at the time of this post) by the SF product team, this feature may see its way into the Lightning Experience. You can vote on the idea here.

Please note that while the title mentions weeks within reporting, custom work weeks have been mentioned in other contexts in some of the ideas that have been merged into this one. What salesforce relative dates?

Salesforce relative date is a period of time that is relative to the current date (last week, last month, etc.).

Relative Date Value (THIS WEEK,NEXT WEEK,LAST WEEK)

About this question

Your answer

1 Answer

More Salesforce discussions

Learn & Explore

Salesforce Tutorials

Salesforce Interview Q&A

Latest Salesforce Blogs

Want answers to more Salesforce questions?

Stay in the loop — it’s free

You’re on the list!