Re: [Axapta-Knowledge-Village] Select empty date field

[Sonny Wibawa Adi]

Hi Nitesh,
 
 
Use nullValue function or dateNull function.
 
For example:

    select * from salesTable where salesTable.DeadLine == nullValue(salesTable.Deadline);
    select * from salesTable where salesTable.DeadLine == dateNull();or
    objRange.value(queryValue(dateNull()));
 
Regards,
 
 
Sonny Wibawa AdiNitesh <[EMAIL PROTECTED]> wrote:




Hi all,
             i want to select  records from a table whose date is empty.i used null, '  '  and "   " in the criteria but it is not working .please help.
 
Regards 
NiteshSharing the knowledge on Axapta. 
		Do you Yahoo!? 
Yahoo! Mail - Easier than ever with enhanced search. Learn more.


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.