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
Posts tonen met het label date. Alle posts tonen
Posts tonen met het label date. Alle posts tonen
woensdag 15 juli 2009
Abonneren op:
Posts (Atom)
