Stamping date automatically

Posted on 2009-04-21
Last Modified: 2013-12-18
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.
Question by:jforget1
    LVL 22

    Accepted 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


    Author Closing Comment

    Thanks a lot, you always know the fix.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

      In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
    Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now