# Bug OP-12785 - Error message "Timestamps contain forbidden values: oneDayAgo" for non-enterprise plan

Project: OpenProject
Status: closed
URL: https://community.openproject.org/work_packages/OP-12785

## Open points

_No work packages_

## Details

| Attribute | Value |
| --- | --- |
| Date | 2023-03-01 –  |
| Priority | Medium |
| Module |  |
| Target versions | 13.0.0 |
| Observed in versions |  |
| Sprint | 13.0.0 |
| Backlog bucket |  |
| Bug found in version (deprecated) |  |
| Found in mobile app version |  |
| Follow-up feedback e-mail |  |
| Requires doc change | No |
| Accessibility | No |
| Pull preview |  |
| List |  |
| Labels |  |

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable |  |
| 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.  Use an instance _without_ any Enterprise plan
2.  Go to the work packages list of a project (default view))
3.  Click Baseline button, and select &quot;Yesterday&quot;, then click &quot;Apply&quot;

### What is the buggy behavior?

*   The list does not update itself
*   The list cells are off-by-one, as shown in this screenshot:
    *   <img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/58365/content">
    *   ID column contains the subject
    *   Subject column contains the type
    *   and so on
*   When trying to add or remove a filter, or when trying to refresh the page, the following error is displayed:   
        _Your view is erroneous and could not be processed._  
           _\* Timestamps contain forbidden values: oneDayAgo@00:00+02:00_
    *   <img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/58366/content">
*   The error does not occur if using an Enterprise plan

### What is the expected behavior?

1.  It should work as intended, displaying the work packages compared to one day ago.
2.  Technically, the initial selection of &quot;baseline: yesterday&quot; lead to a HTTP 400 error (Bad request) with the same error as above &quot;Timestamps contain forbidden values: oneDayAgo@00:00+02:00&quot; but was not visible and the list was wrongly displayed. Ideally the error should be reported and the baseline options should be cleared.

### **Browser Logs**

XHR GET  
http://localhost:3000/api/v3/projects/project-1/queries/default?pageSize=20&amp;offset=1&amp;columns\[\]=id&amp;columns\[\]=subject&amp;columns\[\]=type&amp;columns\[\]=status&amp;columns\[\]=startDate&amp;columns\[\]=dueDate&amp;columns\[\]=duration&amp;showSums=false&amp;timelineVisible=false&amp;highlightingMode=none&amp;includeSubprojects=true&amp;showHierarchies=true&amp;groupBy=&amp;filters=\[\]&amp;sortBy=\[\[&quot;id&quot;,&quot;asc&quot;\]\]×tamps=oneDayAgo@00:00+02:00,PT0S  
\[HTTP/1.1 400 Bad Request 26ms\]

Failed to get /api/v3/projects/project-1/queries/default: HttpErrorResponse

### Environment information

**OpenProject installation type**

*   [ ] Hosted cloud edition
*   [ ] Packaged installation
    *   What distribution?
*   [ ] Docker All-in-one container
*   [ ] Docker-compose installation
*   [x] Other (please specify)
    *   [x] Local Dev environment using dev

**OpenProject version**

future 13.0: commit ca4dc23fb5 from dev branch (Tue Jun 13 16:12:04 2023 +0200)

**Browser**

*   [ ] Chrome
*   [x] Firefox
*   [ ] Safari
*   [ ] Mobile Safari
*   [ ] Other (please specify)
