Hi,
I hope you can help me out here:
Scenario:
I have a SharePoint list with two columns, "Start Date" and "End Date". In PowerApps I have a simple Gallery that I want to filter, the filter will show all items in the list that fall between two dates in the above columns, the date range is 1/4/19 -> 31/3/20. I've had a good troll through these forums and there is a lot about this but using date pickers, as the date is already in the list I've got stuck.
The basic formula I am trying to use is:
Filter(COLLECTION, 'Start Date' >= "1/4/2019" And 'End Date' <= "31/3/2020")
But that causes all sorts of red wigglies.
I am sure this should be possible but my brain is really hurting now, hence the call for help.
Thanks
Rob