cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Filtering data with short date using equal to

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)

1 REPLY 1
Community Support
Community Support

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

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

Top Solution Authors
Top Kudoed Authors
Users online (46,626)