I have SQL data table which has column with date and time. I would like to filter data based on date only which is in text format, I tried below query but that did not help. Any suggestion would be helpful. Thanks
Have you checked the following blog?
Working with date/time values and SQL Server
Please take a try to format both values with DateValue() or DateTimeValue() function,
Distinct(Filter('[dbo].[PowerApps_ReleaseMgmtDetails]', Release=Gallery2.Selected, DateValue(DeploymentDate)=DateValue(Gallery2_2.Selected.Label5_2)), Project)
See if doing it in this way would help.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.