Apex 数式項目で曜日を含む条件を指定する方法

環境
Salesforce

構文

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
CASE(
WEEKDAY(日付),
1, "日曜日",
2, "月曜日",
3, "火曜日",
4, "水曜日",
5, "木曜日",
6, "金曜日",
"土曜日"
)
CASE( WEEKDAY(日付), 1, "日曜日", 2, "月曜日", 3, "火曜日", 4, "水曜日", 5, "木曜日", 6, "金曜日", "土曜日" )
CASE(
  WEEKDAY(日付),
  1, "日曜日",
  2, "月曜日",
  3, "火曜日",
  4, "水曜日",
  5, "木曜日",
  6, "金曜日",
  "土曜日"
)

WEEKDAY関数を使って、入力した日付の曜日を 1 (日曜日) ~ 7 (土曜日) の数値で返します。

操作例
ケースの作成日の曜日を判定し、営業時間の開始時刻を返します。
数式コード

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
CASE(
WEEKDAY(DATEVALUE(CreatedDate)),
0, BusinessHours.SundayStartTime,
1, BusinessHours.MondayStartTime,
2, BusinessHours.TuesdayStartTime,
3, BusinessHours.WednesdayStartTime,
4, BusinessHours.ThursdayStartTime,
5, BusinessHours.FridayStartTime,
BusinessHours.SaturdayStartTime
)
CASE( WEEKDAY(DATEVALUE(CreatedDate)), 0, BusinessHours.SundayStartTime, 1, BusinessHours.MondayStartTime, 2, BusinessHours.TuesdayStartTime, 3, BusinessHours.WednesdayStartTime, 4, BusinessHours.ThursdayStartTime, 5, BusinessHours.FridayStartTime, BusinessHours.SaturdayStartTime )
CASE(
  WEEKDAY(DATEVALUE(CreatedDate)),
  0, BusinessHours.SundayStartTime,
  1, BusinessHours.MondayStartTime,
  2, BusinessHours.TuesdayStartTime,
  3, BusinessHours.WednesdayStartTime,
  4, BusinessHours.ThursdayStartTime,
  5, BusinessHours.FridayStartTime,
  BusinessHours.SaturdayStartTime
)

 

Apex

Posted by arkgame