preloader-matrix

Alfasith

ValidTimeState in child table relation in AX 2012 / D365

Hi,

while select validTimeState(AsOnToday) * from hcmEmployment join hcmWorker
where  hcmWorker.RecId == hcmEmployment .Worker &&
hcmWorker.PersonnelNumber == “1269”
{
print hcmEmployment .ValidFrom;
}
pause;
}

Regards

Leave a Reply

Your email address will not be published.