Hi guys! I have a table with 365 rows (one for each day of the year) I’m creating a view of this table but I’d like to see only a few days. Right now I have this formula thisRow.Date>= (Today()-1) which is fine. But I don’t need to see but maybe 1-2 days ahead. How do I tweak this formula so it won’t show me the other hundred something rows? Thank you!
You want to see days from yesterday to day after tomorrow, right? Here is the formula:
(thisRow.Date >= Today() - 1) And (thisRow.Date <= Today() + 2)
Perfect! Thank you so much! I figured I needed to use And but I messed up doing it. Thanks again.