DateTimeフィールドの計算

Salesforce

Last updated at 2024-05-11Posted at 2023-06-20

問合せから初回対応のリードタイムを出したい

IF(OR(isblank(formulacheck__c.Start_DateTime__c),isblank(formulacheck__c.End_dateTime__c)),NULL,

TEXT(FLOOR( formulacheck__c.End_dateTime__c-formulacheck__c.Start_DateTime__c)) + "日" +

TEXT ( FLOOR( (formulacheck__c.End_dateTime__c-formulacheck__c.Start_DateTime__c  - FLOOR( formulacheck__c.End_dateTime__c-formulacheck__c.Start_DateTime__c))*24)  ) + "時間" +

TEXT(  FLOOR(  (  (formulacheck__c.End_dateTime__c-formulacheck__c.Start_DateTime__c  - FLOOR( formulacheck__c.End_dateTime__c-formulacheck__c.Start_DateTime__c))*24 - FLOOR( (formulacheck__c.End_dateTime__c-formulacheck__c.Start_DateTime__c  - FLOOR( formulacheck__c.End_dateTime__c-formulacheck__c.Start_DateTime__c))*24) )*60 )  ) + "分"

)

Error element Schedule_Cadence_Restart_Time (FlowActionCall). Specify a resume time value at least 1 hour in the future in the ISO 8601 format [2021-06-25T05:38:15.521917Z].

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