CountIf - not working to count "created" date with datepicker?

[Oskarkuus]

I need some help to solve this issue.

I have two datasources, sharepoint lists:

Kop_Lista

Kassa_Lista

In the sharepoint list Kop_Lista

I want to count how many rows have been created at a specific date, the date that the user picks from a datepicker control in Powerapps.

But i cant get that to work by doing this:

CountIf(Kop_Lista;DatePicker1.SelectedDate=Created)

I put above code in Text control in a Label.

I just get 0 as the result even tho i can see i have items created on the date that is selected in the datepicker.

I have also tried this:

CountIf(Kop_Lista;Text(DatePicker1.SelectedDate;DateTimeFormat.ShortDate)=Text(Created;DateTimeFormat.ShortDate))

I dont get any errors. But the result is just 0

My goal after getting the date to work to then add another criteria to the IF statement.

But i need the date to start working.

[RezaDorrani]

@mdevaney 

At SPC 2019, the product team did mention that Date field are on the roadmap and will me made delegable soon

They are sortable (in terms of delegation) but not filterable (in terms of delegation)

[mdevaney]

I am glad to hear that @RezaDorrani  It would be very nice to have that feature today but I understand PowerApps is still maturing and we can't have everything all at once.  Thanks as always for sharing your knowledge and expertise!

[RezaDorrani · Accepted solution]

Update !!!

Date columns are now delegable

[mdevaney]

@RezaDorrani 

Now that's dedication Reza, coming back to this post.  I remember the first time you mentioned this on the forums, and waiting... impatiently.  Now the day is finally here.  Time to celebrate!

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."