Add 1 to a date field

Posted on 2006-05-10
Last Modified: 2013-12-18
I have a field called DateM. I want to have 6 more fields that are dates and each one adds one day to the previous one.

So if someone enters 6/8/06 in Date M, the others would compute when composed as such (and couldn't be edited)

DateT     6/9/06
DateW    6/10/06
DateH     6/11/06
DateF     6/12/06
DateSa   6/13/06
DateSu   6/14/06

Question by:aeonflux2
    1 Comment
    LVL 15

    Accepted Solution

    You should make these fields computed and put the following formula in as their computed values respectively:

    @Adjust(DateM; 0; 0; 1; 0; 0; 0)
    @Adjust(DateM; 0; 0; 2; 0; 0; 0)
    @Adjust(DateM; 0; 0; 3; 0; 0; 0)
    @Adjust(DateM; 0; 0; 4; 0; 0; 0)
    @Adjust(DateM; 0; 0; 5; 0; 0; 0)
    @Adjust(DateM; 0; 0; 6; 0; 0; 0)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
    Article by: Rob
    Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    759 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

    10 Experts available now in Live!

    Get 1:1 Help Now