The validFromDatetime field from the HRPPartyPositionTableRelationship is an Datetime type field and the projTransDate field from the projJournalTable an date type field in the example below.
// Example begin
Timezone timezone = DateTimeUtil::getUserPreferredTimeZone();
;
while select positionTable
where positionTable.HRMReferenceType == 0
&& positionTable.Reference == EmplTable.EmplId
&& positionTable.ValidFromDateTime >= datetobeginUtcDateTime(projJournalTable.ProjTransDate, timezone)
&& positionTable.ValidToDateTime <= datetobeginUtcDateTime(projJournalTable.ProjTransDate, timezone)
{
error("error message");
return;
}
// Example end
Abonneren op:
Reacties posten (Atom)
Geen opmerkingen:
Een reactie posten