Microsoft Dynamics AX (Archived)

How to pick random year in a date?

(0) Share

Report

Posted on by Community Member

I need to pick a random year in a date and date must be the 1-April year will change as per filter.

what kind of function will give me the result? is that mkdate(); or another one?

Please help.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Vilmos Kintera 46,149 on at

Like (0)

Report

RE: How to pick random year in a date?

That is great, please make sure you verify helpful answers with the checkbox next to each post to close the thread.

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
RE: How to pick random year in a date?

Hi,

You can use the following job/code to generate random numbers for the years within the date range dateNull and dateMax using mkdate function. Please let me know if anything is missing.

static void RandomYear(Args _args) { int i; int randomNumber; RandomGenerate randomGenerate; randomGenerate = RandomGenerate::construct(); randomGenerate.parmSeed(new Random().nextInt()); // for (i = 1; i <= 5; i++) { randomNumber = RandomGenerate.randomInt(year(dateNull()), year(dateMax())); // Generates random number within the range datenull and dateMax info(strFmt("%1", mkDate(1,4,randomNumber))); //} }

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to pick random year in a date?

i have use mkdate() as int in last year

Was this reply helpful? Yes No
Vilmos Kintera 46,149 on at

Like (0)

Report

RE: how to pick random year in a date ?

I have updated the example to use a C# namespace, which provides better random range functionality than standard AX.

Kindly mark helpful answer as verified.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report
RE: how to pick random year in a date ?

How about this?

System.Random sysRand = new System.Random(); int years = System.Convert::ToInt32(sysRand.Next(1900, 2154)); info(strFmt('%1', mkDate(01, 04, years)));

Was this reply helpful? Yes No