Discussions

Expand all | Collapse all

calculating dates with date formula.

  • 1.  calculating dates with date formula.

     
    Posted 09-26-2016 16:58

    i have date field(1st Field) and i am trying to add another field that calculates 1 year from first field. for example,

    1st Field (Date Field)

    2nd Field (Formula Date Field) ( this field should show 1 year from 1st field) 

    i tried all i knew but didnt work. 


    Please help



  • 2.  RE: calculating dates with date formula.

    Posted 09-26-2016 19:20
    Try this

    AdjustYear([My date field],1)

    Here is the help on that https://www.quickbase.com/db/6ewwzuuj?a=dr&rid=35&rl=dm7

    It deals with Leap years too.


  • 3.  RE: calculating dates with date formula.

    Posted 09-26-2016 19:24
    You can create a new date-formula field with following type of date-formula for adding one year to the given date.
    AdjustYear([dt1], +1)

    In the above example dt1 is a name of the  date field.

    Replace "dt1" with proper date-field-name to which you are adding one year.

    Neal

    NealPatil @ gmx.com


  • 4.  RE: calculating dates with date formula.

    Posted 01-12-2017 17:52
    What is the formula if you are adding just a day, a week or a month?


  • 5.  RE: calculating dates with date formula.

    Posted 01-12-2017 19:03
    to add a day it would be

    [my date field] + Days(1)

    To adjust the month it would be

    AdjustMonth([my date field],3) to move three months ahead.


  • 6.  RE: calculating dates with date formula.

    Posted 01-12-2017 21:36
    Thank you.