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
Thanks this works!
this one: (dayRange(0,1))
(day(0))..(day(1)), edit, that doesn't work :).
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
That's Great, that's exactly what we need
Thanks Jan-Luuc
select firstonly <Your Table>
where <Your Table>.TransDate > systemDateGet() +1 ;
or
while select <Your Table>
where <Your Table>.TransDate > systemDateGet() +1 ;
{
value = value + X;
}
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!
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)).
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
static void IncDate(Args _args)
{
TransDate transDate = 16\02\2009;
;
transDate++;
print transDate;
pause;
}
to get today date
use systemDateGet() + 1 function
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,836
Most Valuable Professional
nmaenpaa
101,156