web

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

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Date operation in AX u...

Microsoft Dynamics AX (Archived)

Date operation in AX using x++ help!

(0) Share

Report

Report

Posted on by Community Member

Hello,

I want to be able to subtract months from the current date. I have found solutions to add days/months but nothing to go back in time.

Is this possible in AX?

Thanks,

Charu

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Community Member on at

Like (0)

Report

Re: Date operation in AX using x++ help!

I can subtract days by simply doing, for eg. 'today() - 6', but what I really need is months.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 236,513 Most Valuable Professional on at

Like (1)

Report

Re: Date operation in AX using x++ help!

If you know how to add month, why can't you add a negative number of months?

For example, you can use use DateTimeUtil::addMonths(d1, -3) to subtract three months. (This function works with utcdatetime, so you have to convert your date to utcdatetime and back).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Date operation in AX using x++ help!

Thanks Martin, that worked!

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Tocauer 4

#2

Community Member 2

#2

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans