先週、今週などの式

• Formula field: Closed Date = LAST WEEK
• Formula that display Current Week, last week and Next week
• Reporting on Salesforce Files (and Related Records) via Data Loader

20日締めで今月だったらtrueになる式

IF ( DAY( TODAY() ) > 20 ,TEXT( YEAR( TODAY() ) *100 + MONTH(TODAY() ) ),
IF ( MONTH(TODAY() ) = 01, TEXT( YEAR( TODAY() ) - 1) & '12' ,
TEXT( YEAR( TODAY() ) *100 + MONTH(TODAY() ) - 1)
)) = SyougoMonth__c

20日締めで今月だったらtrueになる式

CASE( MONTH(TODAY()),
1,IF ( DAY( TODAY() ) > 20 ,TEXT( (YEAR( TODAY()) -1) *100 + 12) ,TEXT( (YEAR( TODAY()) -1 ) *100 + 11) ) ,
2,IF ( DAY( TODAY() ) > 20 ,TEXT( YEAR( TODAY()) *100 + 1) ,TEXT( (YEAR( TODAY())-1 ) *100 + 12) ) ,
IF ( DAY( TODAY() ) > 20 ,TEXT( YEAR( TODAY() ) *100 + MONTH(TODAY()) -1) ,TEXT( YEAR( TODAY() ) *100 + MONTH(TODAY() ) -2) )
) = SyougoMonth__c

20日締めで今年度、昨年度、来年度のように区分をつける式

IF(AND(Nengetu__c >=
CASE(MONTH(TODAY()),
1,TEXT(YEAR(TODAY())-1) & "/04",
2,TEXT(YEAR(TODAY())-1) & "/04",
3,TEXT(YEAR(TODAY())-1) & "/04",
TEXT(YEAR(TODAY())) & "/04") ,
Nengetu__c <=
CASE(MONTH(TODAY()),
1,TEXT(YEAR(TODAY())) & "/03",
2,TEXT(YEAR(TODAY())) & "/03",
3,TEXT(YEAR(TODAY())) & "/03",
TEXT(YEAR(TODAY())+1) & "/03") ),"this",

IF(AND(Nengetu__c >=
CASE(MONTH(TODAY()),
1,TEXT(YEAR(TODAY())-2) & "/04",
2,TEXT(YEAR(TODAY())-2) & "/04",
3,TEXT(YEAR(TODAY())-2) & "/04",
TEXT(YEAR(TODAY())-1) & "/04") ,
Nengetu__c <=
CASE(MONTH(TODAY()),
1,TEXT(YEAR(TODAY())-1) & "/03",
2,TEXT(YEAR(TODAY())-1) & "/03",
3,TEXT(YEAR(TODAY())-1) & "/03",
TEXT(YEAR(TODAY())) & "/03") ),"last",

IF(AND(Nengetu__c >=
CASE(MONTH(TODAY()),
1,TEXT(YEAR(TODAY())) & "/04",
2,TEXT(YEAR(TODAY())) & "/04",
3,TEXT(YEAR(TODAY())) & "/04",
TEXT(YEAR(TODAY())+1) & "/04") ,
Nengetu__c <=
CASE(MONTH(TODAY()),
1,TEXT(YEAR(TODAY())+1) & "/03",
2,TEXT(YEAR(TODAY())+1) & "/03",
3,TEXT(YEAR(TODAY())+1) & "/03",
TEXT(YEAR(TODAY())+2) & "/03") ),"next",

"other")))