Date filter, searching help !

(0) Share

Report

Posted on by ProtoSup

I have an inventory Sharepoint list, I want to make a filter with combobox for exemple to display uniquely, items which are in stock since : 6month, 1 Year, 2Y, 3Y, 4Y, ect ect

I have a column with de date on entry in stock 'StorageDate' , how can I compare this with the now() function to make the filter action ?

Thanks in advance for your help

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-mingkz-msft Microsoft Employee on at

Like (1)

Report
Hi @ProtoSup,
Do you want to Filter the items in SharePoint list that the difference between StorageDate and now() is less than the value selected in dropdown?
Can you accept using a unified unit (year) in dropdown (replace 6 months with 0.5 year)?
You can try the following formula.

Filter('List Test',DateDiff(Date,Now(),TimeUnit.Months)<=Dropdown3.Selected.Value*12)

Best Regards,
Kyrie

Was this reply helpful? Yes No