Trying to filter or lookup on a date field

[Spreck76]

Okay, been trying a few different solutions I've found on the boards but nothing seems to work. My app is pulling data from an Azure SQL database with a "date" data type. I have entered data using a DatePicker in PowerApps. I am trying to do a simple filter of said data based on a date chosen from a DatePicker. Essentially it is the same DatePicker used to enter the data I want to use to retrieve stored data. I have the Date time zone of the DatePicker set to Local.

When I use a simple label with the code DatePicker1.SelectedDate I see the correct date. When I use a filter on a Gallery for example using the formula:

Filter('[dbo].[GSP_DailyPrices]', Load_Date = DatePicker1.SelectedDate)

I get a blank gallery, no errors, no warnings. Not sure what I'm doing wrong here.

Appreciate the help.

Thanks,

[johnsonjohn]

Changing both dates to text with specifying format can solve the issue.

Text(DataCardValue7.SelectedDate,"[$-en-US]mm-dd-yyyy")=Text(attendance_date,"[$-en-US]mm-dd-yyyy") 

DataCardValue 7 --> for attendance_date--> SQL

[kerridge23]

Thank you johnsonjohn! this worked great. 

Text(DataCardValue7.SelectedDate,"[$-en-US]mm-dd-yyyy")=Text(attendance_date,"[$-en-US]mm-dd-yyyy") 

[Mark2457]

Thanks - not too performant, bit it works for now

It's staggering that the product team cannot do a simple data comparison or allow casting to a date. ALL the befits of rapid development get completely wiped out by wasting hours trying to figure out junk like this