Date condition in select statement

smiley
over 1 year ago

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.
Parents
No Data
Reply
  • 0 Moderators Dynamics MVP over 1 year ago
    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.
Children
Related
Recommended

Copyright 1995-2019 Dynamics User Group, all rights reserved.