Gabe, >Ran into an issue trying to perform a q in q on some data that contains >nulls in a date field. > >It appears the field gets cast one way or the other and thus pops: > >Query Of Queries runtime error. >Unsupported Date type conversion in Query of Queries. > >I need to pull the records even if they are null. Anyone run into this and >come up with a workaround? > >Mx 6.1
If you're using MS SQL, you could use ISNULL() on the date fields to return an empty string instead of the null value. However, I suspect the problem is QoQ is choking trying to compare a date field to an empty string. If this is the case, you might have to try declaring some kind of "null" date (like 1/1/1900.) - Dan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211509 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
