Null Date Question

[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.

 

[John Lane]

Here's what I did:

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