Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

filter sharepoint list for date between two values

Hi I've got a sharepoint list I'm trying to filter a date column which is between two values


list is named CrewMember



- Person (person or Group)

- CrewDate (date)

- VotingPoints (number)


This currently works

Filter(CrewMember, Person.Email = User().Email && CrewDate > Date(Day(01), Month(06), Year(2017)))


But if I add a second date I get no date for example


Filter(CrewMember, Person.Email = User().Email && CrewDate > Date(Day(01), Month(06), Year(2017)) && CrewDate < Date(Day(31), Month(05), Year(2018)))


I also get no data if I use


Filter(CrewMember, Person.Email = User().Email && Date(Day(31), Month(05), Year(2018)) > CrewDate)


I get no error but I also get no data

Helper V
Helper V

Maybe you could try to use If function, to show different filter result according to different condition, since Person.Email = User().Email && CrewDate > Date(Day(01) works. 

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,896)