Filter to show between now and 5 days from now

couponclippingc · 05-07-2021 02:05 PM

Hello,
I am completely new to App Sheet.
I am building myself an app to simply manage a spreadsheet, basic view, add, remove lines.
I am trying to make a slice of data that will only show me rows where the date in a specific column is within the next week.
More specifically, between today and 7 days from today (including today).
I can’t get out of the thought of the following…between (today (), Today() +5)
But I know if I was speaking macro I would be looking to filter with an IF statement and a range perhaps?
Thank you in advance for your time!

Steve

This?

AND(
  ([Date] >= TODAY()),
  ([Date] < (TODAY() + 7))
)

couponclippingc

What is it that I am struggling with here? LOL. I tried to paste it in and look at the test results, but I’m not sure I am following these… phrases here?

couponclippingc

I am trying to make it a conditional filter to create a slice of my data if that helps.
I am working on a coupon database app, and I need a few things actually…

For a “Expiring Soon” page, I want the slice to filter as… If “expires” date is this week (Between today and 7 days from now, including today)
For a “Upcoming Coupons” page, I want the slice to filter as… If “Expires” date is greater than or equal to today, AND if “Published” date is less than or equal to today.

I feel like I am so out of touch with the language. I used to write VBA excel macros for my job, but I haven’t in so long and I CANNOT think correctly for some reason.
Thank you for your help!

Steve

gregdiana1

In your question, you noted that the " date in a specific column is within the next week."

You must use the name of this column and ensure it is of type date. The answer assumed this column name to be [Date] but you must use the column name you refer to where the range of dates you wish to filter appears.

Note that TODAY() is of type DATE and not DATETIME so you must make sure you are comparing apples with apples in terms of COLUMN DATA TYPE.

What is the column name you refer to?

Use
AND( ([YOUR COLUMN NAME] >= TODAY()), ([YOUR COLUMN NAME] <= (TODAY() + 5)))

couponclippingc

AND() worked very well for both of my needs very well, I am slowly catching on to the expressions as a whole now.
Thank you both a million times!!