
Announcements
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
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