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!
Hello, @Lynette!
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.