Microsoft Dynamics AX (Archived)

AX2012 LINQ - How to compare datetime

(0) Share

Report

Posted on by Community Member

hi everyone,

I'm newbie with the AX.

I'm using LinQ to get data from AX server.

Here are my codes:

QueryCollection<ContactPerson> contact = new QueryCollection<ContactPerson>(provider);

var results2 = (from c in contact
where c.ModifiedDateTime >= fromDate

with ModifiedDateTime is ValueType type.

I also tried to use the command Convert.ToDateTime( c.ModifiedDateTime) >= fromDate but it didn't work too.

Please help me to solve this problem.

Thank you very much.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Martin Dráb 237,807 Most Valuable Professional on at

Like (0)

Report

Could you please elaborate the description of your problem? "It didn't work" isn't very detailed.

Was this reply helpful? Yes No
Dick Wenning 8,705 Moderator on at

Like (0)

Report

did you check this example

msdn.microsoft.com/.../jj677293.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

yes Dick Wenning, I've checked that example but there is no example about where by datetime.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

hi Martin Drab,

I just want to filter with datetime. Could you please advise/sample how to filter?

With command Convert.ToDateTime( c.ModifiedDateTime) >= fromDate, I have error is "IQueryable is not recognize Convert..."

Was this reply helpful? Yes No
Martin Dráb 237,807 Most Valuable Professional on at

Like (0)

Report

Thank you, "IQueryable is not recognize Convert" is more specific than "it didn't work", although I'm note sure if it was your original problem. It says that you're trying to convert a type that can't be converted.

I suggest you use the select statement to return a single property and First() to return a single value instead of a collection.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I just want to filter by compare with DateTime type, how could I do?

Was this reply helpful? Yes No
dontran 130 on at

Like (0)

Report
Microsoft.Dynamics.AX.Framework.Linq.Data.dll not support (not handled) convert type
DateTime X++ to system.Datetime of .Net

I'm try add class: Class.DateTimeUtil.axproxy of AX to .Net with code but didn't work.

var results2 = (from c in contact
where DateTimeUtil.parse(c.ModifiedDateTime.ToString()) >= fromDate

P/s: The .NET Framework System.DateTime type and the X++ date type. FromSystem.DateTime, there is no marshaling to the X++ utcdatetime type, and there is no marshaling to the timeOfDay extended data type (which is an int).

Was this reply helpful? Yes No
dontran 130 on at

Like (0)

Report

Another solution for filter with ModifieldDatime in AXProxy

CustTable tbl = new CustTable();

DateTime _fromdate,_todate ;

_fromdate = Convert.ToDateTime("01-01-2015");

_todate = Convert.ToDateTime("01-01-2016");

QueryBuildDataSource queyBuildDataSource = query.addDataSource(tbl.TableId);

QueryBuildRange queryBuildRange = queyBuildDataSource.addRange(61440);

queryBuildRange.value = Global.queryRange(_fromdate, _todate);

p/s: with 61440= ID of field ModifieldDateTime in table CustTable of AX

Was this reply helpful? Yes No