I have two fields, one editabe Date/Time field named “ExpireDate” and one computed field named “Status”. When user compose the form he will enter an expiration date. I want the Status field to read “Expired” if the vlude in the ExpireDate filed is before today. I used the formula below but it does not update automatically
mVar := @Today;
nVar := @If(Expire_Date < mVar ; “License Expired” ; Expire_Date = mVar ; “License Expires Today” ; Expire_Date > mVar ; “License is still Valid” ; " Invalid Expiration Date or Never Expires");
oVar := @Text(Expire_Date);
@If(oVar = “” ; “License Never Expires or Invalid Expiration Date” ; nVar)
Btw, I am new to notes and I don’t know Java or Lotus Scripts
Subject: How to automatically refresh a specific field
It sounds like your question is how to make a field value update itself in unopened documents as they sit on disk. Think about it for a moment, and you should realize that it is unrealistic to try to do this in code written in the form, since form and field formulas run as triggered when the form is open. If your only need is to see which documents are expired in a view, you don’t need to store it in a field; you can simply write the view to categorize/filter/etc. If for view performance or data-related reasons you decide to store the field, simply use a daily scheduled agent to update its value, since once a day is how often date-triggered logic needs to be re-evaluated.