Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Filter on YEAR(date) with _between giving incorrect results #20382

Closed
u12206050 opened this issue Nov 10, 2023 · 0 comments · Fixed by #22410
Closed

Filter on YEAR(date) with _between giving incorrect results #20382

u12206050 opened this issue Nov 10, 2023 · 0 comments · Fixed by #22410
Assignees
Labels

Comments

@u12206050
Copy link
Contributor

u12206050 commented Nov 10, 2023

Describe the Bug

Filtering on the year of the dob field which is a DateTime field, works when just using greater or less than, but when using between it isn't working.

WORKS
Screenshot 2023-11-10 at 14 46 22

DOES NOT WORK!:
Screenshot 2023-11-10 at 14 38 08

BTW; ALSO DOES NOT WORK (Not sure how I even got the Year fn to be like this):
Screenshot 2023-11-10 at 14 43 35

To Reproduce

Filter on a datetime field using between and the YEAR function, potentially on a relationship as well.

Have noticed this since 10.6 but not sure when it might have started.

Directus Version

10.6.3

Hosting Strategy

Self-Hosted (Docker Image)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
Status: ✅ Done
Development

Successfully merging a pull request may close this issue.

3 participants