Show only past 7 days in drop down selection

dcor123 · 2022-11-15T15:03:54.384Z

Screenshot 2022-11-15 at 14.31.543062×608 75.3 KB

Hi

Screenshot 2022-11-15 at 15.04.461318×930 89.5 KB

I saw this post ’ How do I create a repeating group that only shows things with dates in the past 14 days?’
and i tried the expression but it did not work for me.

I have a repeating group filtered by a drop down however I cannot get it to resolve to only show data for the past seven days. When I input the expression Current date/time +(days): -7, the screen goes black (no data in the repeating group). Please see attached screenshot. Ideally I want the drop down to only allow 7 days which can be selected from to filter the repeating group.

Thanks

adamhholmes · 2022-11-15T15:20:48.948Z

date ≥ current date/time +(days): -7

(you might want to round the current date/time down to day first, depending on exactly what data you want to see)…

Also, again depending on what kind of data it is, you might need a second constraint so as not to show items who’s date is in the future.

date < current date/time

dcor123 · 2022-11-15T15:21:52.247Z

Thanks Adam!

system · 2023-01-24T15:04:47.978Z

This topic was automatically closed after 70 days. New replies are no longer allowed.