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

1.2K    Asked by BenjaminMoore in Salesforce , Asked on Apr 23, 2021

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 ?

Answered by Bruce Benedict

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.).



Your Answer

Interviews

Parent Categories