22 July 2011

Query Range for UTCDateTime Fields

If you need to set a query range for a UTCDateTime field the from and to DateTime value should be set using
SysQuery::range(DateTimeUtil::minValue(), DateTimeUtil::utcNow());
Strfmt is also working, but i prefer SysQuery::range
strfmt('%1..', dateEditDateExpectedDepature.dateTimeValue());