O
Opal
I am trying to create a field in my report which will show the number
of days between the LossDate and Today's Date if the issue has a
status of "Open" and if the status is not open (i.e. Closed) I want
to see the number of days between the LossDate and the CMDate
(closed date). I have tried:
DateDifference: IIf ([Status]="Open",DateDiff("d",[LossDate],
[TodaysDate],DateDiff("d",[LossDate],[CMDate])))
but I am getting #Error in the field. Any suggestions?
of days between the LossDate and Today's Date if the issue has a
status of "Open" and if the status is not open (i.e. Closed) I want
to see the number of days between the LossDate and the CMDate
(closed date). I have tried:
DateDifference: IIf ([Status]="Open",DateDiff("d",[LossDate],
[TodaysDate],DateDiff("d",[LossDate],[CMDate])))
but I am getting #Error in the field. Any suggestions?