I've developed a formula that will convert a date field into the week number. See code below.
CEILING((( Trial_Account_Date_Created__c - DATE(YEAR(Trial_Account_Date_Created__c ), 1, 1) + 1) + MOD(DATE(YEAR(Trial_Account_Date_Created__c ), 1, 1) - DATE(1900, 1, 7), 7)) / 7)Now what I want to do is to add the text "Week" before the number in the formula. I tried many things but I got stuck. How can add text before formula, any help would be appreciated
Log in to share your answer and help other learners.
Log in to answerBest Answer · By JanBask Salesforce Expert
Answered on Apr 16, 2021
<strong> You can try below after making the formula return type as</strong> "Text",'Week' + Text(CEILING((( BirthDate- DATE(YEAR(BirthDate), 1, 1) + 1) + MOD(DATE(YEAR(BirthDate), 1, 1) - DATE(1900, 1, 7), 7)) / 7))
Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.
Step-by-step Salesforce guides from industry experts
Common Salesforce interview questions, answered
Guides, tips and career advice on Salesforce from JanBask experts.
Salesforce How to Get Into Salesforce With No Experience
Wondering if you can get a Salesforce job with no experience? Learn how to pick a career path, build real skills, and land your…
Salesforce How to Become a Salesforce Developer Without Experience
No coding background? Learn how to become a Salesforce Developer step by step - skills to build, projects to create, and how to…
Salesforce How to Become a Salesforce Admin With No Experience
No Salesforce Admin experience? Learn how to build real skills, create projects, and land an entry-level Salesforce Admin job…
Salesforce How Long Does It Take to Become a Salesforce Developer?
Wondering how long to learn Salesforce Developer? Most beginners need 6–12 months. See the study time, stage-by-stage roadmap and…