Microsoft Dynamics AX (Archived)

How to get today's +1 date in Dynamics Ax2009 X++?

(0) Share

Report

Posted on by Community Member

Need to be able to select today's + 1 date function inside dynamics ax2009,

As we require this to run a sales orders select.. any help would be appreciated on this

Thanks

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (2)

raelhefn on at

Like (1)

Report

static void IncDate(Args _args)

{

TransDate transDate = 16\02\2009;

;

transDate++;

print transDate;

pause;

}

to get today date

use systemDateGet() + 1 function

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for the reply,

unfortunately I don't need it to create a class.. I just need the select command (single line) to enter in a GUI selection if possible

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (2)

Report
Hi Jordan,

You probably mean a selection in a query, for this you can use the SysQueryRangeUtil.

Below some examples, you can use this in query's so you can use them in recurring batches without the need to change it daily. Give it a try in a testenvironment to see if it meets your requirements. Simply key in the bold statement below in a datefield. In your case it would be (greaterThanDate(1)).

(dayRange(-30,0)) - Results in a date range for the last 30 days: "26-01-2014".."25-02-2014"

(day(-1)) - Results in yesterday's date: 24-02-2014

(day(0)) - Results in today's date: 25-02-2014

(day(1)) - Results in tomorrow's date: 26-02-2014

(greaterThanDate(2)) - Results in every date after today plus 2: > 27-02-2014

(lessThanDate(-1)) - Results in every date of today minus 1: < 24-02-2014

(monthRange(0,2)) - Results in first day till the last day of the month's choosen (0 = current month): "01-02-2014".."30-04-2014"

(yearRange(-1,-1)) - Results in first day till the last day of the chosen year: "01-01-2013".."31-12-2013"

Was this reply helpful? Yes No
Jesus R. ABASCAL 1,450 on at

Like (0)

Report

Hi,

You have many options according your requirements:

info(date2StrXpp(today()+1));
info(DateTimeUtil::toStr(DateTimeUtil::addDays(DateTimeUtil::utcNow(),1)));
info(date2StrXpp(systemDateGet()+1));

Regards!

Was this reply helpful? Yes No
raelhefn on at

Like (0)

Report

select firstonly <Your Table>

where <Your Table>.TransDate > systemDateGet() +1 ;

or

while select <Your Table>

where <Your Table>.TransDate > systemDateGet() +1 ;

{

value = value + X;

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

That's Great, that's exactly what we need

Thanks Jan-Luuc

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

I have just attempted to enter one of the above however it pulls back all results of sales orders on tomorrow's date,

however we require all of current date's results + tomorrow's which Query would we require to meet this ?

Thanks in advance

Jordan

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

(day(0))..(day(1)), edit, that doesn't work :).

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

this one: (dayRange(0,1))

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks this works!

Was this reply helpful? Yes No