Computed date

Hi,

I have a problem with a computed time/date field.

The field should be computed when the field “ActivityFinished” says “Closed”. The “ActivityFinished” field is an editable dialog list with 2 choices: Open og Closed.

The dspActivityFinished is the computed date/time field.

I have tried with the following:

@If (@IsTime(ActivityFinished = “Closed”);dspActivityFinished;@IsDocBeingSaved;@Now;“”)

But it dowsn’t work.

Help !

Thanks in advance

Regards,

Henrik Hvergel

Subject: Computed date

try this

@if(ActivityFinished=“Closed”;@now;“”)

Subject: Computed date

@If (ActivityFinished = “Closed”& @IsDocBeingSaved

& @text(dspActivityFinished)=“”;@Now;dspActivityFinished)

Subject: RE: Computed date

Thanks a lot for your fast help both of you.

I got Rene’s solution to work. :slight_smile: