Hello all,
i am finding strange behavior in below select query.
select workerResidentTaxRegion where workerResidentTaxRegion.Worker == worker.RecId
&& workerResidentTaxRegion.ValidTo == dateMax() && workerResidentTaxRegion.ValidFrom == mkDate(2,1,2019);
when i write this query with giving valid to and valid from data it is returning result but when i don't pass the date values it is not returning the result even though the i am passing worker recID, what is the reason for this and what is solution in this type of scenario as i don't to pass the date values.
P.S the table name is PayrollWorkerResidentTaxRegion and i am also facing similar behavior in other tables too.
Thanks
