Date Formula

[tomparko]

Using Crystal 9 and Oracle 9i.

In a table called MEETING there is a field called DATE (meeting.date) which is populated as follows:

01/01/2004
03/01/2004
05/01/2004
07/01/2004
09/01/2004
11/01/2004
13/01/2004
15/01/2004

And another table called APPOINTMENT links to the MEETING table. This table has a field called APPDATE, which is populated as follows:

10/01/2004

We are wanting a formula to show the next meeting.date after the appointment.appdate hence (using the APPDATE - 10/01/2004) we would want to return 11/01/2004.

Can anyone help with this formula please?

Cheers,

Tom

 

[lbass]

You could create a formula like the following {@nextdate}:

if {table.date} > {table.apptdate} then {table.date} else date(9999,09,09)

Then right click on this formula and insert a summary (minimum). You can then conditionally suppress the summary with:

{@nextdate} = date(9999,09,09)

-LB

 

[tomparko]

Thanks for that lbass. It works perfect!

Tom