Tuesday, February 23, 2010

UTCDateTime field Query Range by Date in Dynamics Ax

static void RAJ_UTCDateTimeQueryRange(Args _args)
{
Query q = new Query();
QueryRun qr;
QueryBuildDataSource qbds;
CustTable custTable;
Transdate tmpCreatedDate = 02\02\2010; // dd-mm-yyyy

;

qbds = q.addDataSource(tableNum(CustTable));
qbds.addRange(fieldNum(CustTable, CreatedDateTime)).value(date2StrUsr(tmpCreatedDate));

qr = new QueryRun(q);

while(qr.next())
{
custTable = qr.get(tableNum(CustTable));

info(strfmt("Account Num: %1, Name: %2", custTable.AccountNum, custTable.Name));
}
}

No comments: