# Bug SPPM-65 - 500 when filtering by date field and specifying too big number

Project: Stream Project Portfolio Management
Status: closed
URL: https://community.openproject.org/work_packages/SPPM-65

## Open points

_No work packages_

## Details

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | Medium |
| Module |  |
| Target versions | 15.1.0 |
| Observed in versions | 14.2.0 |
| Bug found in version (deprecated) | 14.2.x |
| Requires doc change | No |
| Accessibility | No |
| Pull preview |  |
| List |  |
| Labels |  |

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable | Ivan Kuchin |
| Product manager |  |
| Developers |  |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Planning

| Attribute | Value |
| --- | --- |
| Relevance |  |

## Costs

| Attribute | Value |
| --- | --- |
| Votes |  |
| Work |  |
| Labor costs |  |

## Description

### Steps to reproduce

1.  There should be at least one date/timestamp field available to filter projects on (Created on, Last activity at, …)
    
2.  Open any project query, for example the default one [http://localhost:3000/projects](http://localhost:3000/projects)
    
3.  Add a filter by the date/timestamp field, operator will be `less than days ago` by default and specify `10000000` as value
    
4.  Click on "Apply"
    

### What is the buggy behavior?

*   Page with status 500 is shown
    

### What is the expected behavior?

*   From Ivan: Do not show any notification
    

### **Logs**

```log
PG::DatetimeFieldOverflow: ERROR:  timestamp out of range: "25356-11-13 23:59:59.999999 BC"
LINE 1: ...jects.active IN ('t')) AND (projects.created_at > '25356-11-...
```

### Screenshots and other files

_<img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/105530/content">_

### Environment information

**OpenProject installation type**

*   Hosted cloud edition
    
*   Packaged installation
    
    *   What distribution?
        
*   Docker All-in-one container
    
*   Docker-compose installation
    
*   Other (please specify)
    

**OpenProject version**

_Checked on dev@a64e23d2f9480a73820bddc9954ee90bd20b2bfe_