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

2005-01-03 Thread 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 froma 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.

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

2005-01-03 Thread Subrahmanyam Mamidi 




Hi Niteshh,

dateNull() will be usefull to find empty dates.

You may want to use s" elect Table where table.datefiled == dateNull() .
Nitesh [EMAIL PROTECTED] wrote:




Hi all,
 i want to select records froma 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 - Find what you need with new 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.

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

2005-01-03 Thread akash malohatra 

Hi,

try 01/01/1900 . Axapta stores this date for null
dates in the database.

Regards
Akash
--- Nitesh [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 
 Nitesh
 


__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


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:
http://docs.yahoo.com/info/terms/