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

  • Show details Hide details
  • 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:

    Already have an account? Login here!




Instant HelpGet instant SAP help. Sign up for our Free Essentials Plan.


Related SAP Error Messages

Click the links below to see the following related messages:

Click on this link to search all SAP messages.


Rating
ERPlingo's SAP support assistant is amazing. Saves me countless hours trying to solve complex SAP issues myself. It's a real game changer!
Rate 1
Thomas Michael
SAP Consultant, Author & Speaker