Dynamics Community Forum Thread Details

Range value on Datetime fields

Hello

I have a view with a utcdatetime field "PO created date time" and trying to filter data on it. Using the view on form as datasource

I have added 2 fields on the form for from date and to date to filter the data.

I am trying to filter the data using below code in Execute query method and doesn't work

fDateTime = ctrlFromDate.dateTimeValue();
tDateTime = ctrlToDate.dateTimeValue();

startDate   = DateTimeUtil::date(fDateTime);
endDate     = DateTimeUtil::date(tDateTime);

startTime   = str2time("08:30:00 am");     
endTime     = str2time("09:00:00 am");

rangeStart = DateTimeUtil::newDateTime(startDate,startTime);
rangeEnd   = DateTimeUtil::newDateTime(endDate,endTime);

this.query().dataSourceTable(tableNum(ReceiptLinesView)).clearRange(fieldNum(ReceiptLinesView, POCreatedDateTime));

this.query().dataSourceTable(tableNum(ReceiptLinesView)).addRange(fieldNum(ReceiptLinesView, POCreatedDateTime)).value(queryRange(rangeStart, rangeEnd));

I tried to hard code like this below with almost same code and it works, but I want to dynamically filter using form controls by above method.

startDate   = 01\09\2025;       // day\month\year
            endDate     = 24\09\2025;     // day\month\year

            startTime   = str2time("08:30:00 am");     //GMT, NOT user time zone - this is how stored in the table
            endTime     = str2time("09:00:00 am");
                        
            rangeStart = DateTimeUtil::newDateTime(startDate,startTime);
            rangeEnd   = DateTimeUtil::newDateTime(endDate,endTime);

            this.query().dataSourceTable(tableNum(ReceiptLinesView)).clearRange(fieldNum(ReceiptLinesView, POCreatedDateTime));

            this.query().dataSourceTable(tableNum(ReceiptLinesView)).addRange(fieldNum(ReceiptLinesView, POCreatedDateTime)).value(queryRange(rangeStart, rangeEnd));

I am clueless on what is going on

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL