Want to Add a date formula field to Another Date formula field

Dynamics 365 Business Central/NAV Developers Forum
1

Hello Friends,

I want to Add a dateformula type field to another Dateformula type. Ex- I have a Variable of Type DateFormula and In Setup I have a field of Type DateFormula which have Value like 6M or 120D or 1Y. then I am generating 10 rows so I want Data like 6M,12M,18M,…(If I give 6M in Setup). How would I achive this plz suggest me.

THANKS

2

Try this:

EVALUATE(NewDateFormula,FORMAT(DateFormula) + ‘+’ + FORMAT(DateFormula2));

But I think you should test that both DateFormula and DateFormal2 have been set before doing this. It would create an invalid dateformula if they are not set.