Question Status

Verified
Anita Spirax asked a question on 29 Mar 2015 8:01 PM

Hi, In the Sales Order list, I want to search the list for sales orders where the promised delivery date is null (blank). What is the search criteria for null in a date range field?

Reply
mmv responded on 29 Mar 2015 8:21 PM

Hi Anita,

You may use the below code:-

SETRANGE("Promised Delivery Date",0D) 

Best Regards,

MMV

Reply
Verified Answer
Anita Spirax responded on 29 Mar 2015 8:32 PM

Thanks MMV, I actually needed it for the filters on the View List.

I have just found that it is two single quotes ''

Reply
mmv responded on 29 Mar 2015 8:34 PM

Yes, if you want to set the Property, it is with '' (two single quotes).

Reply
Verified Answer
Anita Spirax responded on 29 Mar 2015 8:32 PM

Thanks MMV, I actually needed it for the filters on the View List.

I have just found that it is two single quotes ''

Reply