Forum Discussion
Filter on today's date in Sharepoint List doesn't work
- Jan 05, 2024
Ashley_Vdk As per the Microsoft documentation, it is correct:
Try using [VANDAAG] instead of [TODAY].
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Hey!
Ik heb hetzelfde probleem en ik vraag me af of dit komt door de vertaling van de term [Today]?.
I have the same problem and I wonder if it's a bad translation of the term [Today] towards Dutch?
Is there already a solution?
Kind regards,
Ashley
- ganeshsanapJan 05, 2024MVP
Ashley_Vdk As per the Microsoft documentation, it is correct:
Try using [VANDAAG] instead of [TODAY].
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- Ashley_VdkJan 05, 2024Copper Contributor
Hi ganeshsanap ,
I did use the correct language, but it does not work.
I get the error that it is not possible to use "or" with an indexed column (error A), but if I remove the index on the column I get the error that I need an indexed column because my list is more than 5000 items (error B). Although my view is not more than 5000.
If I click on "ok" when I get error A, then I see that the filtering with [Vandaag] did not work and the filtering on my column Soort (PW) did work.
I tried a lot of things, but I don't quite understand what I'm doing wrong. I also don't find the correct information online, mostly the help video's or websites don't use indexed columns or have a test library of 5 or so documents.