# Questions? We have answers.

## Summary

Learn about the error codes MBER1193, MBER1194, and 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 {rowNumber}. Convert the invalid date to {expectedValue} format, then re-import the file to try again._

---

## What do these errors 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 are warnings, but could alert you to possible errors.
2. Most out-of-range years (such as 2209) are typos or other minor errors — 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.**

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.

---