Monday, February 13, 2012

Cara memfilter data format datetime dengan parameter date

static void dpr_datetime(Args _args)
{
    HRMPartyEmployeeRelationship    hrmPartyEmployeeRelationship;
    Date        dateFilter;
    int         row;
    ;
    dateFilter = 07/11/2011 //use backslash

    while select hrmPartyEmployeeRelationship where
    hrmPartyEmployeeRelationship.ValidFromDateTime >= datetobeginUtcDateTime(dateFilter,DateTimeUtil::getUserPreferredTimeZone())
    && hrmPartyEmployeeRelationship.ValidFromDateTime <= datetobeginUtcDateTime(dateFilter,DateTimeUtil::getUserPreferredTimeZone())
    {
        row++;
        info(strfmt('%1 %2 %3 %4 %5', row, dateFilter, hrmPartyEmployeeRelationship.EmplId,
hrmPartyEmployeeRelationship.ValidFromDateTime,
        hrmPartyEmployeeRelationship.ValidToDateTime));
    }
}

No comments: