Null Date Question

  • Thread starter Thread starter John Lane
  • Start date Start date
J

John Lane

How can I union two queries, one with valid dates and the other with null
dates and not get a type mismatch error? If I make the null date field an
empty string (ie., ""), it unions, but the software turns the dates into
strings. I want to keep it date type so it can be sorted by date. Thanks.
 
Here's what I did:

Did an IsDate, and if true, did a DateValue, if false, inseted Null. Works
great!
 
Back
Top