Axapta - Don't Miss One Second When filtering Between Two DateTime Fields

Views (1332)

metin emre

502

Like(0)

Report

If we take time 00:00 of day after last day and use < instead of <= we don't miss even one second:

fromDate = DateTimeUtil::newDateTime(FromDateEdit.dateValue(),0,DateTimeUtil::getCompanyTimeZone());
toDate = DateTimeUtil::newDateTime(ToDateEdit.dateValue()+1,0,DateTimeUtil::getCompanyTimeZone());

while select count(RecId) from serviceOrderTable
where serviceOrderTable.createdDateTime >= fromDate
&& serviceOrderTable.createdDateTime < toDate

This was originally posted here.