cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yakimo
Advocate II
Advocate II

date filtering problem

When I try to filter the dataset by Date, I get an error:

"Inner exception: we cannot apply operator < to types Date and DateTimeZone"

What it is for DateTimeZone type? The field dato is datetime sql type

Cannot figure out how to filter my recordset by Date 😞

Any help out there?

 

Thanks

 filterByDate.JPG

10 REPLIES 10
anatal52
Frequent Visitor

Filter('[dbo].[table]', datetime >= Date(1900,1,1) )

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

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

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (33,846)