How to: Get FromDate, ToDate in Query range AX 2012 R3

(0) Share

Report

Posted on by Community Member

Hi experts,

I want to get FromDate, ToDate like pic below:

I try to use this code:

_QueryBuildDataSource = _QueryRun.query().dataSourceTable(tableNum(ProdTable));
_QueryBuildRange = _QueryBuildDataSource.findRange(fieldNum(ProdTable, FinishedDate));

if(_QueryBuildRange)
info(strFmt("%1", _QueryBuildRange.value()));

--> the result: 01/12/2016..10/04/2017

Anyone has simple solution to help me convert _QueryBuildRange.value() to FromDate, ToDate?

Tks all.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

Simply you can add date ranges in query range as below shown.

Thanks

Suresh

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please look into below links which is solved earlier.

community.dynamics.com/.../199073

Also look into the link, which is related to your solution.

stackoverflow.com/.../advanced-query-range

Thanks

Suresh

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!
Try this in the init() of your formDataSource on the ProdTable table if you want to apply the range:

SysQuery::findOrCreateRange(this.queryBuildDataSource(),
fieldNum(ProdTable, FinishedDate)).value(SysQuery::range(12\01\2016, 04\10\2017);

If you want to convert it from a string back to dates, then you need to use subStr() and str2date() methods.

https://msdn.microsoft.com/en-us/library/aa554244.aspx

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Hi Thiennd,

It's a strange requirement, however, you can use subStr() or strSplit() to get first part of the string 01/12/2016 and second part of the string 10/04/2017, then you can convert string to date using str2Date() function.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Suresh potlakayala, Vilmos Kintera and ievgen Miroshnikov

Thanks for your replies.

But I found out some problems in this topic may be the same as my issue:

https://community.dynamics.com/ax/f/33/t/40866

Was this reply helpful? Yes No