Upcoming Dates

[MintonMagic]

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!

[LaRetta]

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: