convertion date

Hi Nav Geneious,

I have convert days into month

Ex:

Date of Application:= Mar/1/2013

Tenure := 60D, converting the tenure into months has to come 2months, can u tell the formula…ASAP

Regards

Packiya

NoOfDaysInMonth :=
DATE2DMY(CALCDATE(‘CM’,DMY2DATE(01,MonthNumber,YearNumber)),1);

NoOfDaysInMonth–Type Integer

MonthNumber – Type Integer (Jan=1…Dec=12)

YearNumber-- Type Integer (e.g 2012,2013…)

In this process, may we assume that you want to compute a date based on the Date of Application and the Tenure? Using the values you’ve supplied here, what should the new date be? And, if you need to add a number of months to the base date, as you’ve implied, then why not make the Tenure 2M instead of 60D?

Hi Paciya,

Did you get an answer to your question? Did it help you? The members and moderators here on DUG use our spare time and help you for free, all we ask in return is that you spent a few seconds to let us know if we helped you solve your problem.

If any of the suggestions helped you solve your question/problem, then please click the “Verify Solution” on the answer that helped you, so that we can see that your problem is now “resolved”. Otherwise let us know how if there is something else you like to know.

Have a nice day! [:)]