how to change date from one fiscal year to other?

(0) Share

Report

Posted on by Community Member

Hi ,

i have table(demotable) with field named 'startDate', now i need to roll over each month and store each months name
problem is:

how to change & store this date after 31/12/2017 to 01/01/2018

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

István Orosz 2,137 on at

Like (0)

Report

Hi,

What is the exact type of 'startDate'? If you want to add only one day to a date, which is stored as UTCDateTime in your table, you can use the DateTimeUtil::addDays() method.

Regards,

István

Was this reply helpful? Yes No
Suggested answer

Rohin 4,624 on at

Like (0)

Report

Do you mean by

Valid Time State Tables and Date Effective Data [AX 2012]

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

thanks for the quick response Istvan

can u tell me if i want to change month wise , what is the function?

Was this reply helpful? Yes No
Suggested answer

Rohin 4,624 on at

Like (0)

Report

then simply use DateTimeUtil::addMonth()

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

and if i want to add to a user added date of "Transdate" EDT,

then???

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

Have a look at this:

[View:https://stoneridgesoftware.com/dynamics-ax-all-about-dates-and-x/:750:50]

[View:https://msdn.microsoft.com/en-us/library/aa865135.aspx:750:50]

As you see in the documentation, you can offset it in multiple ways. Add/subtract days, or int values, etc.

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Hi,

You can use the following job/code to get the month names between given date intervals

static void MonthName(Args _args) { TransDate startDate, EndDate; int number; startDate = mkDate(31,12,2017); endDate = mkDate(1,1,2018); while (startDate < EndDate) { number = mthOfYr(startDate); info(strFmt("Month Name: %1", mthName(number))); startDate = nextMth(startDate); } }

Was this reply helpful? Yes No
Suggested answer

István Orosz 2,137 on at

Like (0)

Report

Hi,

TransDate is originated from Date, which does not contain time zone infromation, maybe the simplest way is to convert it into UTCDateTime and use the methods of DateTimeUtil class.

Regards,

István

Was this reply helpful? Yes No