# Workspace Date Dropdown Ignores custom formatting of the date

**URL:** <https://community.forestadmin.com/t/workspace-date-dropdown-ignores-custom-formatting-of-the-date/6593>\
**Category:** Help me!\
**Created:** [August 23, 2023, 3:35pm UTC](https://community.forestadmin.com/t/workspace-date-dropdown-ignores-custom-formatting-of-the-date/6593 "2023-08-23T15:35:29Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Simon\_BRAMI1](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/simon_brami1/32/2753_2.png) [@Simon\_BRAMI1](https://community.forestadmin.com/u/Simon_BRAMI1)\
**Post date:** [August 23, 2023, 3:35pm UTC](https://community.forestadmin.com/t/workspace-date-dropdown-ignores-custom-formatting-of-the-date/6593/1 "2023-08-23T15:35:29Z")

</div>

Hey,

I am building a worspace to search things based on a date field which has DD/MM/YYYY formatting setup which works fine everywhere except in the workspace when using the Dropdown Widget:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/forest/original/2X/b/b655b2087e404e4bb6dfa9f3f8f0b9f00b05fa54.png)

It has instead YYYY-MM-DD formatting.

Is this a miss ?

Thanks team!

---

<div class="post-metadata">

**Author:** ![nbouliol](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/nbouliol/32/5777_2.png) [@nbouliol](https://community.forestadmin.com/u/nbouliol)\
**Post date:** [August 23, 2023, 4:03pm UTC](https://community.forestadmin.com/t/workspace-date-dropdown-ignores-custom-formatting-of-the-date/6593/2 "2023-08-23T16:03:03Z")

</div>

Hello @Simon_BRAMI1

Thank you for reaching out !

I can reproduce this bug on my end.

We’ll keep you updated once this has been fixed.

Regards,  
Nicolas

---

<div class="post-metadata">

**Author:** ![Simon\_BRAMI1](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/simon_brami1/32/2753_2.png) [@Simon\_BRAMI1](https://community.forestadmin.com/u/Simon_BRAMI1)\
**Post date:** [September 6, 2023, 8:37am UTC](https://community.forestadmin.com/t/workspace-date-dropdown-ignores-custom-formatting-of-the-date/6593/3 "2023-09-06T08:37:50Z")

</div>

Hey @nbouliol,

We’re having another issue with the same dropdown, fyi the field targeted is a DATEONLY field, and we cannot search any value even with Search Enabled.

It’s trying to compare my search string with the date without a CAST so nothing happens.

The backend returns this error:

```javascript
[forest] 🌳🌳🌳 Unexpected error: operator does not exist: date ~~ unknown
{
  "name": "SequelizeDatabaseError",
  "parent": {
    "length": 201,
    "name": "error",
    "severity": "ERROR",
    "code": "42883",
    "hint": "No operator matches the given name and argument types. You might need to add explicit type casts.",
    "position": "199",
    "file": "parse_oper.c",
    "line": "647",
    "routine": "op_error",
    "sql": "SELECT \"catalogue_item_id\" AS \"catalogueItemId\", \"end_opco\" AS \"endOpco\", \"catalogue_item_id\" AS \"catalogueItemId\" FROM \"public\".\"catalogue_item\" AS \"catalogueItem\" WHERE \"catalogueItem\".\"end_opco\" LIKE '2023-11-25' LIMIT 100 OFFSET 0;"
  },
  "original": {
    "length": 201,
    "name": "error",
    "severity": "ERROR",
    "code": "42883",
    "hint": "No operator matches the given name and argument types. You might need to add explicit type casts.",
    "position": "199",
    "file": "parse_oper.c",
    "line": "647",
    "routine": "op_error",
    "sql": "SELECT \"catalogue_item_id\" AS \"catalogueItemId\", \"end_opco\" AS \"endOpco\", \"catalogue_item_id\" AS \"catalogueItemId\" FROM \"public\".\"catalogue_item\" AS \"catalogueItem\" WHERE \"catalogueItem\".\"end_opco\" LIKE '2023-11-25' LIMIT 100 OFFSET 0;"
  },

```

It’s very blocking for us, what do you recommend to use in our workspace instead ?

Thanks

---

<div class="post-metadata">

**Author:** ![anon34731316](https://avatars.discourse-cdn.com/v4/letter/a/eada6e/32.png) [@anon34731316](https://community.forestadmin.com/u/anon34731316)\
**Post date:** [September 13, 2023, 3:11pm UTC](https://community.forestadmin.com/t/workspace-date-dropdown-ignores-custom-formatting-of-the-date/6593/4 "2023-09-13T15:11:44Z")

</div>

Hello @Simon_BRAMI1,

Sorry for the response delay.

To be honest, here we’re missing one component: **the Date Picker component**.  
It will enable to select a timestamp / date and from this, you’ll be able to filter out your other components.  
This component will surely come out soon, I just can’t tell you exactly when.

The issue you’re pointing in your latest message is due to the fact that Sequelize doesn’t know how to do to know if a date or a dateonly contains a value (the search is about “containing some characters”).  
So the search should not be used with Date fields.

I guess for now, waiting for the Date Picker component, the solution would be to create a dynamic smart dropdown to make it do what you’d like.

We’ll let you know once there are some news on the topic.

Cheers!

---

<div class="post-metadata">

**Author:** ![anon34731316](https://avatars.discourse-cdn.com/v4/letter/a/eada6e/32.png) [@anon34731316](https://community.forestadmin.com/u/anon34731316)\
**Post date:** [November 21, 2023, 8:25am UTC](https://community.forestadmin.com/t/workspace-date-dropdown-ignores-custom-formatting-of-the-date/6593/6 "2023-11-21T08:25:17Z")

</div>

Hello @Simon_BRAMI1,

I hope you’re doing great.

This message just to let you know that the new Date Picker component in Workspace has been released.  
I hope you’ve seen that news!  
Let me know if it helps you’re use cases and if you have any feeback.

Cheers!