Symptom
Facing error when assigning the field using calculation.
You faced error "Data format for AAAAA is invalid. Use DURATION."
AAAAA is a Date Time -Duration Field.
Environment
- SAP Sales Service Cloud Version 2
- SAP Service Cloud Version 2
Reproducing the Issue
In the determination:
You set the assignment like following:
{extensions/AAAAA} = ( ( $CURRENT_DATETIME() ) - {extensions/PastDateTime} )
Cause
The calculation result would be negative if you use late datetime to subtract the early time.
The negative result would not match the Data Type
Resolution
Please kindly do subtract the late time from the early time.
Example:
{extensions/AAAAA} = ( {extensions/PastDateTime} - ( $CURRENT_DATETIME() ) )
Keywords
Data format for is invalid. Use DURATION. , KBA , CEC-CRM-CZM-CUL , Custom Logic for for SAP Sales/Service Cloud , Problem