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
-
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
-
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. -
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
Content aside
- 5 yrs agoLast active
- 3Replies
- 2463Views