How do I keep a date field set to date status selected?

HCL Domino Domino Forum
1

I have a field called “actualreview” that sets the date to the date when the “Status” field is “Assigned”. When document is opened the day after the status is set to “assigned”, the date changes to the current date.

The formula in the “actualreview” field is:

@If(@Contains(Status;“Assigned”);@SetField(“actualreview”;@Today);@ThisValue).

Any suggestions?

2

Subject: How do I keep a date field set to date status selected?

Thank you both. The field is working.

3

Subject: How do I keep a date field set to date status selected?

it’s working as designed. the field is computed so as long as your IF statement evaluates to TRUE then it will recalculate. What you might want to do is use this code instead:

@If(@Contains(Status;“Assigned”) & actualreview =“”;@SetField(“actualreview”;@Today);@ThisValue)

This assumes that actualreview is blank prior to setting the date value.

4

Subject: RE: How do I keep a date field set to date status selected?

And since we are in the computed value of actualreview (unless I mixed something up), there’s no reason to use @SetField.

@If(

@Contains(Status; “Assigned”) & @ThisValue =“”;

@Today;

@ThisValue

)

5

Subject: RE: How do I keep a date field set to date status selected?

so true, always more than 1 way to skin a cat, as they say.