Unanswered

variable to set latest date and earliest date

(1) Share

Report

Posted on by joel914823

557

I'm trying to set a slider so that I can use that to filter by created date in my data. How can I set a variable to earliest date and latest date in my created date column?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Mitanshu 1,650 Moderator on at

Like (1)

Report
Assuming you have a SharePoint List, you can use formula as below:

Min: First(Sort('YourSharePointList',Created,SortOrder.Ascending)).Created Max: First(Sort('YourSharePointList',Created,SortOrder.Descending)).Created

I didn't suggest to use Min() function because it is not delegable in SharePoint.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
joel914823 557 on at

Like (1)

Report

@happyume Thanks for your help! I was trying to do a datediff between the two variables, but running into an error - would you happen to know why (I put the datediff in the Max), see screen shot, any help is appreciated.

Was this reply helpful? Yes No
Mitanshu 1,650 Moderator on at

Like (1)

Report
Earliest_CreatedDate and Latest_CreatedDate_1 are Controls and not a Date. You need to obtain value of the Control and then convert into Date.

Try:

DateValue(Earliest_CreatedDate.Text)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No