LINQ unable to query using ModifiedDateTime field - compile and runtime errors

(0) Share

Report

Posted on by FO user

199

Hello all,

With LINQ in a C# service I am trying to query a AX table and retrieve only the data that was modified after a specific date and time. The compiler is giving a compile error: "Operator '>' cannot be applied to operands of type 'System.ValueType' and 'System.DateTime'.

Here is my code. The cutOffDateTime variable is a DateTime type.

I have tried converting CreatedDateTime to DateTime but that just removes the VS compiler error and then I get the following error during runtime: The type 'System.DateTime' for the query operator is not Queryable!

The CreatedDateTime property is enabled on the table in question.

Help will be much appreciated.

I have the same question (0)