• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 228
  • Last Modified:

Stamping date automatically

Have an interesting one here. Have a form which will be used to track some training requirements. Have a completion date which they have asked to be calculated off the value of a status field. The status is by Default "Not Started", once the person will be starting the training that status will be changed to "In Progress" the completion date is then supposed to calculate to one year from the date the status field was changed to In Progress". One note, the status will continue to be changed as they progress, Completed etc.

Anyone know of a way where I can trigger that one year "timer" and have it stay fixed even after the status has changed? I am open to suggestions here.
1 Solution

Create a computed date field with the formula below.

The first expression leaves the data alone if it is already populated.
The second expression assigns the date only if the status is "In Progress".
    @ThisValue != ""; @ThisValue;
    StatusField = "In Progress"; @Adjust(@Today ; 1; 0; 0; 0; 0; 0);

Open in new window

jforget1Author Commented:
Thanks a lot, you always know the fix.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now