Salesforceの数式項目でExcel関数：ISOWEEKNUM( )と同じ結果を実現する：
数式項目「日付が年度の何週目」
FLOOR( ( StartDay__c - DATE( YEAR( StartDay__c - WEEKDAY( StartDay__c -1) + 4 ) , 1 , 3 ) + WEEKDAY( DATE( YEAR( StartDay__c - WEEKDAY( StartDay__c -1) + 4 ) , 1 , 3 ) ) + 5 ) / 7)
More than 3 years have passed since last update.
Salesforce数式項目_Excel.ISOWEEKNUM関数
Last updated at Posted at 2021-06-26
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme