Rabu, 30 Desember 2015

Re: [MS_AccessPros] Re: If IsNull(OptionDate)

 

John & Ben-
I'll also try this one. And let you know. Thanks.
Best Regards,
Kevin




发自我的小米手机
在 "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>,2015年12月31日 上午1:16写道:

 

Good tip, Ben!


John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)



On Dec 30, 2015, at 5:22 PM, Ben Sevier bwsevier@sbcglobal.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I usually use If Isdate([datefield]) to check - if it's null, won't be a date, also handles issues with improper dates.

Ben Sevier
San Diego, CA




__._,_.___

Posted by: zhaoliqingoffice <zhaoliqingoffice@163.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (12)

.

__,_._,___

Tidak ada komentar:

Posting Komentar