March 4, 200718 yr Hi all, I have a table with some event dates and I have a "home" screen where I would like to show only future dates from this table. Is there anyway to do this? I thought I might be able to with a portal, but I have failed miserably. Thanks in advance!
March 4, 200718 yr I don't know if this is two different tables or only one. It doesn't matter anyway ... In your Home table, create a calculation called cToday (result is DATE) with: Get ( CurrentDate ) Be sure to CHECK the Storage options to 'Do not store calculation results." You would join to your Events table as follows: Home::cToday < Events::Date LaRetta :wink2:
Create an account or sign in to comment