cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlanCampbell
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

 

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

1 REPLY 1
Leo09
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

Announcements
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)