How To Filter Blank Dates in Query
How To Filter Blank Dates in Query
(OP)
I have a table that contains a date field (dtnDOB). I want to pull all records from this table that have a value in this field. I've tried the following queries with no luck:
select * from <table> where dtndob<>''
select * from <table> where dtndob<>0
select * from <table> where dtndob>0
I'm not sure how to for the WHERE clause so that the result set excludes blank dates.
select * from <table> where dtndob<>''
select * from <table> where dtndob<>0
select * from <table> where dtndob>0
I'm not sure how to for the WHERE clause so that the result set excludes blank dates.
RE: How To Filter Blank Dates in Query
RE: How To Filter Blank Dates in Query
http://www.tek-tips.com/viewthread.cfm?qid=1115432