Need Access formula to choose between 2 dates! 1

[beeorlando]

I have numerous fields that calculate dates off one date field.
the first field contains an "actual" date
the rest of the fields contain a formula that adds days to the date, like this:

DateAdd("y",+45,[Expr1])

Each date keys off one another to create a forecast report.

The problem:

One of the automatic calculated dates is a deadline. If the deadline is extended the rest of the forecasted dates will not reflect that so I need to add an "actual deadline" date to be used in that instance.

Question:

What do I need to add to the formula so that it will choose between the 2 dates? If there is no "extended" date, it will choose the default and if there is an "extended" date it will choose that one.

The agents at the office are counting on me solving this problem - I would appreciate any help out there!! Thanks!!

Carla

 

[CosmoKramer]

Try:

=IIf(IsNull([Extended_Date]), [Actual_Date], [Extended_Date])

 

[beeorlando]

CosmoKramer,

Thanks for your help - it worked perfectly!