cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Re: Trying to filter or lookup on a date field

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

Highlighted
Frequent Visitor

Re: Trying to filter or lookup on a date field

Thank you johnsonjohn! this worked great. 

 

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

Helper II
Helper II

Re: Trying to filter or lookup on a date field

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (12,230)