Filtering data with short date using equal to

[arnav2109]

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

Distinct(Filter('[dbo].[PowerApps_ReleaseMgmtDetails]',Release=Gallery2.Selected,DeploymentDate=Gallery2_2.Selected.Label5_2),Project)

[v-micsh-msft]

Hi @arnav2109,

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.

Regards,

Michael