Form method problem

Finance and Operations/AX Developer Forum
1

Hi to all

(i write the below code in from lave in modified method )

In the table every record has signOnDate and SignOffDate .my requirement is if i give the AsOnDate , it check SingnonDate and signnOf date and give the records. i write the below code for that . it is not working good . any one plz help mee

select firstOnly ProjId,CrewId,SignOnDate,SignOffDate from CrewMovementLine

where CrewMovementLine.ProjId == PersonnelOnBoardTable.ProjId

&& CrewMovementLine.CrewId == PersonnelOnBoardLine.EmployeeID

&& CrewMovementLine.SignOnDate >= PersonnelOnBoardTable.AsOnDate

&& CrewMovementLine.SignOffDate <= PersonnelOnBoardTable.AsOnDate;

2

Hi venkata, welcome to Dynamics User Group.

Could you please elaborate “it is not working good”?

Please give also some attention to which forum you use (I’ll move your question to the Developer forum), the title (your problem seems to be related to ranges in select statement, regardless whether it’s in a form or not) and tags. Thank you!