Hi
I have a table with notes.
User type date note
The chart works well, also whenn i do a search with (only user xxx notes).
Bud when i search a date range (01.01.2010 till 11.05.2010) it says no data.
When i search for dates in the year 2009 it works also?!?
My DB date field ist a datetime field. (date saved as 2009-04-28 00:00:00)
My sql query looks like this.
SELECT
NoteID,
COUNT(NoteID) AS STotal,
type,
date,
user,
FROM Notes
GROUP BY type
It is possible to search between dates?
THX for any help