End of Month

sabzam

Hi Everybody,

I need to get the end of month for a date provided. Is this possible with Navision.

I'm assuming that I should use ROUNDDATETIME but I'm not sure how to use it.

kriki

datEndOfMonth := CALCDATE('<CM>',datSomeDate);

DenSter

And start of the month:

datStartOfMonth := CALCDATE('<-CM>',datSomeDate);

Asallai

Do you mean the Last Day of a month?

Input: dateValue
Output: dateLast

IF DATE2DMY(dateValue,2) < 12 THEN
dateLast:=DMY2DATE(1,DATE2DMY(dateValue,2)+1,DATE2DMY(dateValue,3))
ELSE
 dateLast := DMY2DATE(1,1,DATE2DMY(dateValue,3)+1);
dateLast := CALCDATE('-1D',dateLast);

DenSter

Asallai wrote:

Do you mean the Last Day of a month?

Yes that is what he meant, and you do not need that much code, there is a very simple CALCDATE commend for that:

kriki wrote:

datEndOfMonth := CALCDATE('<CM>',datSomeDate);

Asallai

DenSter wrote:

Asallai wrote:

Do you mean the Last Day of a month?

Yes that is what he meant, and you do not need that much code, there is a very simple CALCDATE commend for that:

kriki wrote:

datEndOfMonth := CALCDATE('<CM>',datSomeDate);

Thanks! Better late then never!

sabzam

Thanks Kriki, problem solved!