英訳する時の補助

Salesforce

Last updated at 2024-08-21Posted at 2022-03-01

"January",31,
"February",28,
"March",31,
"April",30,
"May",31,
"June",30,
"July",31,
"August",31,
"September",30,
"October",31,
"November",30,
"December",31,
30)

CASE(MID(Custom__c, 4, 3),
"Jan", 1, "Feb", 2, "Mar", 3, "Apr", 4, "May", 5, "Jun", 6,
"Jul", 7, "Aug", 8, "Sep", 9, "Oct", 10, "Nov", 11, "Dec", 12, 0)

日曜日　Sunday = Sun. = Su.
月曜日　Monday= Mon.= Mo.
火曜日　Tuesday= Tue.(Tues.) = Tu.
水曜日　Wednesday= Wed.= We.
木曜日　Thursday= Thu.= Th.
金曜日　Friday= Fri.= Fr.
土曜日　Saturday= Sat.= Sa.

Row Level Formula to Group by Date

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

英語での回答例

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up