---
title: Unexpected dates cleaning
description: Unexpected dates are dates that differ significantly from other observations. It may be due to normal variability or due to an error. It is similar to…
---

[Skip to content](https://help.easymedstat.com/support/solutions/articles/77000517694-unexpected-dates-cleaning#main-content)

English

Show submenu for translations

![](https://help.easymedstat.com/hs-fs/hubfs/Logo%20EMS%20HQ%20Noir-1.png?width=366&height=70&name=Logo%20EMS%20HQ%20Noir-1.png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Open a ticket](https://t3jiy.share-eu1.hsforms.com/2pRawwxfuSS6Scx4Qn4KSPA)

[Open a ticket](https://t3jiy.share-eu1.hsforms.com/2pRawwxfuSS6Scx4Qn4KSPA)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [EasyMedStat Knowledge Base](https://help.easymedstat.com/?hsLang=en)
2. [Monitoring](https://help.easymedstat.com/monitoring?hsLang=en)
3. [Clean data](https://help.easymedstat.com/monitoring?hsLang=en#clean-data)

# Unexpected dates cleaning

Unexpected dates are dates that differ significantly from other observations. It may be due to normal variability or due to an error. It is similar to numeric outliers but with event variables.

# How are unexpected dates detected?

The data cleaner will look for unexpected dates by assessing values which are far lower than Q1 (first quarter) and far higher than Q3 (third quarter). This is called the [Tukey's fences](https://en.wikipedia.org/wiki/Outlier) method.

Any data greater than Q3 + 5 IQR or lower than Q1 - 5 IQR will be detected as an outlier.

# How to clean data?

The process is similar to the one used for numeric outliers. Please check Numeric outliers cleaning for more information.

- [Account](https://help.easymedstat.com/account?hsLang=en#main-content)

    - [Account](https://help.easymedstat.com/account?hsLang=en#account)
- [Collect data](https://help.easymedstat.com/collect-data?hsLang=en#main-content)

    - [Questionnaires (ePRO)](https://help.easymedstat.com/collect-data?hsLang=en#questionnaires-epro)
    - [Add and edit patients](https://help.easymedstat.com/collect-data?hsLang=en#add-and-edit-patients)
    - [Randomization](https://help.easymedstat.com/collect-data?hsLang=en#randomization)
    - [Export](https://help.easymedstat.com/collect-data?hsLang=en#export)
    - [Create a series / eCRF](https://help.easymedstat.com/collect-data?hsLang=en#create-a-series-ecrf)
    - [Multilingual studies](https://help.easymedstat.com/collect-data?hsLang=en#multilingual-studies)
- [Variables](https://help.easymedstat.com/variables?hsLang=en#main-content)

    - [Organize in categories](https://help.easymedstat.com/variables?hsLang=en#organize-in-categories)
    - [Dynamic Variables](https://help.easymedstat.com/variables?hsLang=en#dynamic-variables)
    - [Manage variables](https://help.easymedstat.com/variables?hsLang=en#manage-variables)
- [Statistical analyses](https://help.easymedstat.com/statistical-analyses?hsLang=en#main-content)

    - [Statistical tests](https://help.easymedstat.com/statistical-analyses?hsLang=en#statistical-tests)
    - [Compare groups](https://help.easymedstat.com/statistical-analyses?hsLang=en#compare-groups)
    - [Multivariate analysis](https://help.easymedstat.com/statistical-analyses?hsLang=en#multivariate-analysis)
    - [Filter patients](https://help.easymedstat.com/statistical-analyses?hsLang=en#filter-patients)
    - [Descriptive Statistics](https://help.easymedstat.com/statistical-analyses?hsLang=en#descriptive-statistics)
- [Collaborate](https://help.easymedstat.com/collaborate?hsLang=en#main-content)

    - [Share your series](https://help.easymedstat.com/collaborate?hsLang=en#share-your-series)
    - [Manage your organization](https://help.easymedstat.com/collaborate?hsLang=en#manage-your-organization)
- [Monitoring](https://help.easymedstat.com/monitoring?hsLang=en#main-content)

    - [Automations](https://help.easymedstat.com/monitoring?hsLang=en#automations)
    - [Electronic Signatures](https://help.easymedstat.com/monitoring?hsLang=en#electronic-signatures)
    - [Queries](https://help.easymedstat.com/monitoring?hsLang=en#queries)
    - [Clean data](https://help.easymedstat.com/monitoring?hsLang=en#clean-data)

[![](https://help.easymedstat.com/hs-fs/hubfs/Logo%20EMS%20HQ%20Noir-1.png?width=366&height=70&name=Logo%20EMS%20HQ%20Noir-1.png)](http://www.easymedstat.com)

<https://www.linkedin.com/company/easymedstat/> <https://www.youtube.com/@easymedstat9719> [mailto:support@easymedstat.com](mailto:support@easymedstat.com)

Copyright © 2026, EasyMedStat