I need to filter a gallery based on date in my sql server table.
using a date picker.
the date in sql server look like
2021-02-26 15:57:17.157
Filter('[dbo].[LogIn_and_LogOut_Daily]', NSC_ID_Racfid = time_racfid.Text && Daily_Logged_In = DatePicker1.SelectedDate)
this is not working ?
Dave
Hi @Anonymous
There are a number of reasons for the complicated interaction between SQL dates and PowerApps. Please check this page in the documentation and see if one of the conditions applies. https://powerapps.microsoft.com/en-us/blog/working-with-datetime-values-in-sql/
Share
Report
All responses (
Answers (
339
