How To Fix FDT_EXPRESSIONS081 - &1 ne correspond .pas au standard ISO pour le formatage de dates/heures.

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 081

• Message text: &1 ne correspond .pas au standard ISO pour le formatage de dates/heures.

Quelle est la cause de ce problème?

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.

Réponse du système

The system cannot import the spreadsheet data.

Comment corriger cette erreur?

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)

Procédure pour les administrateurs système

Le système émet un message d'erreur et ne vous permettra pas de poursuivre cette transaction tant que l'erreur n'est pas résolue.

Extrait du message d'erreur du système SAP. Copyright SAP SE.