İsmail Ozcan

public static void UTCDateTimeConversion() { UTCDateTime dateTime; date tmpDate; TimeOfDay tmpTime; CustTable cTable = CustTable::find("1101"); ; // Extracted date & Time from UTCDateTime datatype to individulal variable dateTime = cTable.createdDateTime; tmpDate = DateTimeUtil::date(dateTime); tmpTime = DateTimeUtil::time(DateTimeUtil::applyTimeZoneOffset(dateTime, DateTimeUtil::getUserPreferredTimeZone())); info(strfmt("Date: %1 and Time: %2.", tmpDate, time2str(tmpTime,1,2))); // assign UTCDateTime varriable by using two individual field dateTime = DateTimeUtil::newDateTime(12\05\2010, timeNow()); info(strfmt("UTCDateTime: %1.",dateTime)); }

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)); } }