Comparing to columns

[rynorem]

If I have a date column and another column with another consistant date, Can I make a criteria to compare one to the other. Ex:

END_DATE Today's_DATE
06 Feb 05 15 Jun 06
12 Feb 05 15 Jun 06
01 Jan 06 15 Jun 06
26 Mar 06 15 Jun 06
18 Aug 06 15 Jun 06
28 Dec 06 15 Jun 06

Can I make a criteria that will only show the END_DATE data that is before Today's DATE? Does it need to be a new column or can I place it in the criteria of one of these column.

 

[Bobadopolis]

You shoudn't need to store todays date! You shoud delete that column/field.

Place your criteria in the END_DATE field: e.g.

<Date()

Will return dates before today's date.

Or you could perform a calculation on that date e.g.

>DateAdd('m', -6, Date())

Will return records from within the last 6 months.

Bobadopolis