Lesson: 06 | Function (CASE)

Notes
Video

Notes

Field: Today__c = 12/12/2021

Let's create another field with the data type Formula;

Data Type: Formula

Formula Return Type: Text

Field Label: Which month?

Field Name (Auto): Which_month__c

Formula:

CASE(
MONTH(Today__c),
1, "January",
2, "February",
3, "March",
4, "April",
5, "May",
6, "June",
7, "July",
8, "August",
9, "September",
10, "October",
11, "November",
"December"
)

MONTH(Today__c) = 12

Output: Which_month__c = December

Prev You need to login to have access to the quizzes. Next

Mastered by 142 users.

Administrator Course

A. My Personal Information (9 lessons)

B. Company Settings (8 lessons)

C. Object and Fields (35 lessons)

D. Users (8 lessons)

E. Security (14 lessons)

F. Data (5 lessons)

G. Reports & Dashboards (8 lessons)

H. Feature Settings (9 lessons)

I. Standard Objects (14 lessons)

J. User Interface (2 lessons)

K. Lightning App Builder (25 lessons)

L. Process Automation (2 lessons)

M. Email (2 lessons)

N. Formulas Functions (56 lessons)

O. Miscellaneous (1 lessons)

You need to complete all the quizzes before certification.

Go to top

Login to your account

Lesson: 06 | Function (CASE)

Notes

Administrator Course