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

sharad

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

thegunzo

NewDate := CALCDATE(Setup.DateFormula,CALCDATE(TheOtherDateFormula,OriginalDate));

casanova

hi..
how about if i want to add Dateformula + dateformula = dateformula
for example
Field1 = 5D
Field2 = 10D

so Field3 ==> Field1 + Field2 = 5D + 10D = 15D
how to do that?
thanks

matttrax

You would pretty much be rewriting the logic to parse the date formula and add it together. Just let NAV handle it for you behind the scenes. +5D+10D is exactly the same as +15D

casanova

matttrax wrote:

You would pretty much be rewriting the logic to parse the date formula and add it together. Just let NAV handle it for you behind the scenes. +5D+10D is exactly the same as +15D

if i directly add these 2 fields
it wont work

i must calculate as integer,
and then add 'D' to become text format
after that evaluate to become dateformula type