Salesforce: 在formula中得到当前月份的最后一天的日期

DATE(
YEAR( TODAY() ) ,
Month( TODAY() ),
CASE( MONTH(TODAY() ),
  1, 31,
  2, IF( MOD( YEAR(TODAY()) , 4) = 0, 29, 28),
  3, 31,
  4, 30,
  5, 31,
  6, 30,
  7, 31,
  8, 31,
  9, 30,
  10, 31,
  11, 30,
  12, 31,
  0
)
)

posted @ 2021-01-25 18:33  Clsriz  阅读(132)  评论(0编辑  收藏  举报