Add time interval to a date field with a button

T

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

Ninox Profile

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

T

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.

Ninox Profile

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

Reply