How to filter date range on field CreatedDateTime in AX

Finance and Operations/AX Developer Forum
1

Hii Master,

How to filter date range on field CreatedDateTime in AX. ?

I’m trying to convert fromDt & toDate from TransDate to utdDateTime, and I insert fromDtConvert into range but I got Error (Like Pic 2).

Please advise, thank you

this’s my code.

CreatedDateTime.jpg
CreatedDateTime.jpg1191×344 74.4 KB

Pic 2

pastedimage1508386325994v2.png

2

Which line of code is causing that error?

3

When I fill date (from & to) and click OK, I got the debug view

Like this,

debugger.jpg
debugger.jpg1044×528 159 KB

What kind of code is actually for the createdDateTime column filter ? I’ve tried converting from TransDate to UtcDateTime but still error (I always get the debug view)

Please advice, thanks

4

The issue seems to be with setting the parameter but not with the filtering.
Check the data types you are using in data contract class (or) show us your methods in contract class (including class declaration).

5

I just wanna, How can i use filter TransDate (data type) on createddatetime field ?

does for filter createddatetime have to use utcdatetime data type ?

parmClass.jpg

6

Not necessary. You can still use from and to as the date types and convert them to utcDateTime while applying the range.

You have done it right initially.

7

while currently, I use utcdatetme data type for parameter

yaa maybe, i will try it with this code

static void ConvertDate2DateTime(Args _args)

{

TransDate fromDate,toDate;

TimeZone tz;

UtcDateTime fDateTime,tDateTime;

;

fromDate = mkDate(01,06,2017);

toDate = mkDate(30,06,2017);

fDateTime = Global::datetobeginUtcDateTime(fromDate,tz);

tDateTime = Global::datetoendUtcDateTime(toDate,tz);

print fDateTime;

print tDateTime;

pause;

}

Ref: http://kollidynamics.blogspot.co.id/2011/06/convert-date-to-utcdatetime.html