Trying to filter or lookup on a date field

[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