Further after trouble shooting....I am able to find the output of the query in query analyser giving rise to a date value(single).
But the preview on infopath given the following error
The query cannot be run for the following DataObject: Report connection
The XML data returned from the data source does not match the XML Schema for this form. ...