# Date Filters over Weaviate data

**URL:** <https://forum.weaviate.io/t/date-filters-over-weaviate-data/600>\
**Category:** Support\
**Tags:** developer-experience\
**Created:** [August 30, 2023, 7:59pm UTC](https://forum.weaviate.io/t/date-filters-over-weaviate-data/600 "2023-08-30T19:59:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mick\_Cunningham](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.weaviate.io/mick_cunningham/32/425_2.png) [@Mick\_Cunningham](https://forum.weaviate.io/u/Mick_Cunningham)\
**Post date:** [August 30, 2023, 7:59pm UTC](https://forum.weaviate.io/t/date-filters-over-weaviate-data/600/1 "2023-08-30T19:59:21Z")

</div>

I’m pulling data from mongo to weaviate for semantic vector search. The date format is in ISO, but is saved in Weaviate as a string (mistakenly) : “{‘$date’: ‘2023-08-08T19:00:00.000Z’}”. Is there any way I can query like this:

where\_filter = {  
“path”: [“date”],  
“operator”: “GreaterThan”,  
“valueText”: **Here is where I can convert my date string to whatever is compatible**  
}

in python:

self.weaviate\_client   
.query.get(schema, [\*fields\_to\_search, “\_additional {certainty}”])   
.with\_near\_vector(vec)   
.with\_where(where\_filter)   
.with\_limit(5000)   
.do()

Or do I need to run an update to convert the date type to RFC in Weaviate before I can begin filtering on the field?

---

<div class="post-metadata">

**Author:** ![DudaNogueira](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.weaviate.io/dudanogueira/32/7846_2.png) [@DudaNogueira](https://forum.weaviate.io/u/DudaNogueira)\
**Post date:** [August 31, 2023, 11:44am UTC](https://forum.weaviate.io/t/date-filters-over-weaviate-data/600/2 "2023-08-31T11:44:23Z")

</div>

Hi @Mick_Cunningham ! Welcome to our community 🤗

You will have to convert them. Weaviate will understand your data as string, and will not be able to compare it with a date.

Also, you will need to change the datatype to a `date` one:

> **[Data types | Weaviate - vector database](https://weaviate.io/developers/weaviate/config-refs/datatypes#datatype-date)**
>
> \- Configuration: Schema

Let me know if this helps.

Thanks!