SAP Knowledge Base Article - Public

3573115 - Data format for AAAAA is invalid. Use DURATION.

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

Product

SAP Sales Cloud and SAP Service Cloud Version 2 1.0