Dateformular addition

ara3n

Hello
It's been a while since I've used dateformular fields. You can't just add them.

So far I've basically done this. Convert it to string and concatenate it.


evaluate(DateFormularA,format(DateFormularB) + '+' +
format(DateFormularC));


So
DateFormularB := 2D;
DateFormularC := 2D;
then
DateFormularA := 2D + 2D;

And it works

Is there a better way to do this?

zeninoleg

I tried summing the DataFormulas but It does not work.... At least I could not make it work.
I tried even this:

MESSAGE('%1', CALCDATE(DateFormula1 + DateFormula2, WORKDATE) - WORKDATE);

still the same message, however

MESSAGE('%1', CALCDATE(DateFormula1, WORKDATE) - WORKDATE);

Gives the number of days in the DataFormula1 - 2D gives 2 and 2M gives 61.
So theoretically you can sum 2 integers with number of days, get the difference, and add this difference to you existing date
On another hand, your approach is MUCH easier............ :whistle:

ara3n

Great. Thanks you.

kriki

[Topic moved from Navision forum to Navision Tips & Tricks forum]
It's worth it!