I created this query and with certain dates it works, but with others it yields no results. The results for the dates that it works for are way off, do I have the date format in the correct order Month, Day, Year? For instance this query produces no results:
SELECT n.Caption, n.IP_Address, v.Caption, v.VolumePercentUsed, v.StatCollection, vh.MaxDiskUsed, vh.PercentDiskUsed, vh.DateTime FROM Nodes n
INNER JOIN Volumes v ON n.NodeID=v.NodeID
INNER JOIN VolumeUsage_Hourly vh ON v.NodeID=vh.NodeID
WHERE (vh.DateTime BETWEEN CONVERT(DATETIME, '05/10/2015') AND CONVERT(DATETIME, '05/14/2015'))
And n.IP_Address = '10.24.250.107'
ORDER BY vh.[DateTime] DESC
But, if I change the first date to '05/01/2015' then it will show me results from 05/01 to 05/06/2015. I know it's something simple probably, but I am blind to it right now.
