Date condition in select statement

Finance and Operations/AX Developer Forum
1

Hi,

I need to find packingslip id for an sales order with from and to date.

while select cust where cust.SalesId == “SO-100000” && cust.DeliveryDate >= fdate && cust

{
info(strfmt("%1",cust.PackingSlipId));
}

May i know how to add the date condition in whileselect statement?

thanks.

2

while select custPackingSlipJour
where custPackingSlipJour.SalesId == “SO-100000”
&& (custPackingSlipJour.DeliveryDate >= fromDate
&& custPackingSlipJour.DeliveryDate <= toDate)
{
info(strfmt("%1",custPackingSlipJour.PackingSlipId));
}

If you want to build a date, then use mkDate function.

3

So i need to declare the fromdate as mkdate(8/5/2016) and todate as mkdate(8/24/2016)
is it right?

4

Where are you using this code?
Example - mkDate(25,01,2018)

5

I’m trying in job, kranthi.

6

Then you can use mkDate function.