CMS Filter has fales positives for Date Types

Attributes
,
1

Hello,
I have a client side which i worked on 2 years ago that caused a problem with fs cms filter. I’m filtering by date and using the format D.M.YYYY. It works well and everything, but i noticed one weird little thing:

If an Event is at 21.10.2024 and i filter for 1.10.2024 it will also be returned, because 1.10.2024 is completely inside of 21.10.2024.
If Webflow would offer an Date Format of DD.MM.YYYY that would be an easy fix, but we don’t have that option.

Anybody an Idea on how i could optimize that?
Here is a Link with an Example Filter applied that will return false events.

https://www.degginger.de/programm?startdate=1.10.2024

Thank you for looking in to that!

2

Hey @stoesselleon - are you able to share a Webflow preview link?

3

@stoesselleon have you tried changing the date format in your flatpickr code?

To something like:

dateFormat: "d-m-Y",
4

Thanks for jumping in @yogdog!

@stoesselleon Could you please let us know how the test goes?

5

@yogdog thank you for the input!

As long as Webflow does not support giving out the dates as DD.MM.YYYY, setting the flatpickr to handle another dateFormat won’t be working.

To work around i could in theory reformat all of the dates with custom code but i think that’s a lot effort.

Is there no way to have cms filter look for “exact match” ?

I thought maybe with v2 coming there would be a way to maybe adjust that.

6

@stoesselleon but if I change the active filter to 01.10.2024, the filter works as expected:
https://www.degginger.de/programm?startdate=01.10.2024

So I think if we can change the output from the data picker to be formatted properly, your problem will be solved.

If you’re able to share a preview link to the Webflow project, it will be easier to see the setup and offer the right advice.

7

ah okay i see what you mean. I’ll try that. But I still think that this would be a Feature Request.

1 Like
8

Yeah, let us know how you get on.

If you still have problems and you’re not able to share the Webflow shareable link, then if you could paste the code from the date picker embed, I’d be happy to help make suggestions to edit the code

1 Like