Because I couldn't add these conditions into view in CRM (which requires to check today's date is between 2 date fields in Opportunity record), I would like to add them in PowerApp formula but somehow I can't get them to work:
SortByColumns(Search(Filter(Opportunities,'Opportunities (Views)'.'My Open Opportunities','Program Pre-Start Date' <= Today(),'Program Post-Start Date' >= Today()), OppoTextSearchBox.Text, "name"), "estimatedclosedate", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))
'Program Pre-Start Date' and 'Program Post-Start Date' are fields in Opportunity record and I would like to filter to show only Opportunity records if today is between these 2 days.
Please help!!