Populating a field based on a date range of two other fields

[actionman007]

Hi,

I have currently two fields, a start date and an end date. Then I have another field which is an empty field.

What I would like to be able to do is run a calculation that goes along the lines of.

Does 06/04/07 appear in the range of "date1" and "date2" if so put an X into "empty field"

That make sense?

Cheers,

Dan ;)

[Raybaudi]

This is the calculation for the 3rd field:

( but you have to have a fourth date field to enter something like "06/04/07" )

Case(

FourthField ≥ start date and FourthField ≤ end date ; "X"

)