0

Add time interval to a date field with a button

Is it possible to add the time interval to a date field or date formula field, with a button?

3 replies

null
    • Support
    • 6 yrs ago
    • Reported - view

    Hi Adam, 

    It is possible to add data into fields. Could you please explain please a little bit more precise, what you are trying to achieve? Thanks.

    Jörg

    • Testbeeld
    • 6 yrs ago
    • Reported - view

    I need two types of repeating time intervals.

    1) Repeat after completion
    Date 1 + Time interval = Date 2
    If the job is done before or after Date 2
    (With, for example, a button)
    Date 1 = Date 2
    etc.

    2) Repeat at date
    Date 1 + Time interval = Date 2
    If Date 2 is <today
    Date 1 = Date 2
    etc.

    • Support
    • 6 yrs ago
    • Reported - view

    Hi Adam, 

    the function of the button could be: 

     

    'Repeat_Date' := Date1 + 2

     

    That would fill the field 'Repeat_Date' with the date of the field Date1 plus 2 days.

    If you like to add a condition to the formula, you could do it like that: 

     

    if Date2 < today()

    then 

    'Repeat_Date' := Date1 + 2

    else

    'Repeat_Date' := Date1 + 4

    end

     

    Kind regards, Jörg

Login to reply

Content aside

  • 6 yrs agoLast active
  • 3Replies
  • 2468Views