How To Fix FDT_EXPRESSIONS081 - &1 is not a valid ISO-formatted timepoint

FDT_EXPRESSIONS081 - Overview

• Message type: E = Error

• Message class: FDT_EXPRESSIONS - Formula & Derivation Tool: Expressions

• Message number: 081

• Message text: &1 is not a valid ISO-formatted timepoint

What causes this issue?

You are trying to import spreadsheet data from a Microsoft Excel file
into a decision table or into the simulation tool. However, the
spreadsheet contains timepoint values that are not formatted according
to the applicable ISO standard 8601 for date and time formatting.

System Response

The system cannot import the spreadsheet data.

How to fix this error?

Correct the formatting of the timepoint values in the spreadsheet.
Note: You may want to check the 'Help' sheet in the Microsoft Excel
workbook as it is created by the 'Export to Excel' function. Here, you
find an overview of all the allowed operators and data type formats that
can be imported into BRFplus.
Valid formats for the different timepoint types are:
1 - Date: YYYY-MM-DD , e.g 2013-09-01 for the 1st September 2013
2 - Time: hh:mm:ss or Thh:mm:ss , e.g. T12:34:56 (letter 'T' is
optional)
3 - Date and Time: YYYY-MM-DDThh:mm:ss , e.g 2013-09-01T12:34:56 (letter
'T' must be used as delimiter)
4 - UTC: YYYY-MM-DDThh:mm:ssZ , e.g 2013-09-01T12:34:56Z (letter 'Z' is
the zone designator for the zero UTC offset )
7 - Date and Time with offset to UTC: YYYY-MM-DDThh:mm:ss[+|-]hh:mm ,
e.g 2013-09-01T12:34:56+02:00 (this timepoint type is available only in
releases of SAP NetWeaver used as a basis for SAP Business ByDesign,
that is, release 800 or higher, or a specially configured version of
release 730)

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message FDT_EXPRESSIONS081 - &1 is not a valid ISO-formatted timepoint ?

  The SAP error message FDT_EXPRESSIONS081 indicates that a value provided for a timepoint is not in a valid ISO 8601 format. This error typically arises when working with date and time expressions in SAP systems, particularly in contexts involving data transformation or processing.
  
  Cause:
  The error occurs when:
  
  The input value for a timepoint does not conform to the ISO 8601 standard, which specifies a format for representing date and time. For example, a valid ISO 8601 timepoint might look like 2023-10-05T14:30:00Z (representing October 5, 2023, at 14:30 UTC).
  The value may be missing, incorrectly formatted, or contain invalid characters.
  The timepoint might be in a different format (e.g., MM/DD/YYYY or DD-MM-YYYY) that is not recognized as valid by the system.
  
  
  Solution:
  To resolve this error, you can take the following steps:
  
  
  Check the Input Format: Ensure that the timepoint you are providing is in the correct ISO 8601 format. The format should generally be:
  
  Date: YYYY-MM-DD
  Time: HH:MM:SS (optional)
  Timezone: