Questions? We have answers.

Date issues (MBER1193 MBER1194 MBER1134)

  • Updated

Summary

Learn about the error codes MBER1193, MBER1194, & MBER1134 and how to resolve them.


Symptom

MBER1193

The date in the {columnName} column on row {rowNumber} appears to be set in the future. Verify the validity of the data before proceeding. Please ensure that the contents of your data set are valid. - Args({row=5102834, column=7, date=2209-01-02})

MBER1194

The date in the {columnName} column on row {rowNumber} appears to be outside of the expected range. Verify the validity of the data before proceeding.

MBER1134

MindBridge detected an invalid date in column {columnName], row {row}. Convert the invalid date to {expectedValue] format, then re-import the file to try again. If the issue persists, grant MindBridge access to your engagement so Customer Support can dig into the issue.


What does this error mean?

  • Dates may not be in the correct format
  • Dates may be formatted inconsistently
  • Dates may contain errors
  • Dates may fall outside of the expected analysis period


Resolution

Verify that the years in your date column(s) are correct

  1. If all years are within a 25 year range, you can choose to ignore MBER1193 and MBER1194.
    • Note: These errors are warnings, but could alert you to possible errors.
  2. Most out-of-range years, such as 2209 for example, tend to be typos or other minor errors — please consult with your client.

Check for invalid date formats or invalid values (MBER1134)

Sometimes dates in an Excel column do not appear in the same format, including being in an Excel numeric format (i.e., a number that represents the Excel value of the date).

    1. Select the entire column, then select Format > Cells (keyboard shortcut Ctrl-1 on PC or ⌘1 on Mac)
    2. Select Number, then Date, then select Type: YYYY-MM-DD.mceclip1__2_.png

You can also check for invalid values, including letters, text, errors such as #N/A, #VALUE!, #NAME?

  • The presence of letters/text could indicate that some column data was shifted over, and/or has broken lines (an entry that should be on one row got split into two or more rows, often due to newline or carriage return characters within a field).
  • Ask your client for a better data export if you find more than a few shifted columns or broken lines.


Anything else on your mind? Chat with us or submit a request for further assistance.

Was this article helpful?