Hi,
I'm experiencing some weirdness with Query of Queries on openbd.
I have a dataset that looks like this:
query [long version]
FIRSTMEETINGDATE LASTMEETINGDATE
1 2009-01-17 00:00:00.0 2009-09-08 00:00:00.0
Query Source: Query of Queries
If I then run this query against it:
select min(firstMeetingDate) as firstMeetingDate, max(lastMeetingDate)
as lastMeetingDate
from qMaster
The min(firstMeetingDate) is returning an empty string.
Any ideas? Is min() supported on dates with QoQ in openbluedragon?
Andrew.
--~--~---------~--~----~------------~-------~--~----~
Open BlueDragon Public Mailing List
http://groups.google.com/group/openbd?hl=en
official site @ http://www.openbluedragon.org/
!! save a network - trim replies before posting !!
-~----------~----~----~----~------~----~------~--~---
