web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) How to increment date ...

Microsoft Dynamics AX (Archived)

How to increment date 21/01/2015 automatically X++

(0) Share

Report

Report

Posted on by Codehunter

10,280

I need to insert that date like

21/02/2015

21/03/2015

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Community Member on at

Like (1)

Report

you can use nextmth function

TransDate t = mkdate(1,1,2015);

t = nextmth(t);

Was this reply helpful? Yes No
Bilal Issa 4,370 on at

Like (0)

Report

Hi ,

I agree with Xavier and you can also use dateMthFwd(initialStartDate, 1);

Regards,

Bilal

Was this reply helpful? Yes No
Suggested answer

PA-22040759-0 6,194 on at

Like (0)

Report

nextMth will wack the date after hitting uneven months.

Try this, which will change the date from the 31th to the 29th in february, but also after hitting february:

static void TestNextMth(Args _args)

{

date d = nextMth(31\12\1995);

print d;

d = nextMth(d);

print d;

d = nextMth(d);

print d;

pause;

}

You can also use .NET System.DateTime.AddMonth.

dateMthFwd and System.DateTime.AddMonth gets it right:

static void TestDateMthFwd(Args _args)
{
    date d = mkDate(31, 12, 1995);

    print dateMthFwd(d, 1);
    print dateMthFwd(d, 2);
    print dateMthFwd(d, 3);
    pause;
}

static void TestAddMonths(Args _args)

{

System.DateTime dateTime = new System.DateTime(1995, 12, 31);

print dateTime.AddMonths(1);

print dateTime.AddMonths(2);

print dateTime.AddMonths(3);

pause;

}

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 4 Most Valuable Professional

#1

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans