I have a strange behavior with one of my tables its shows duplicate entries as on the bellow image.
I should have an entry for each date.
Any help will be much appreciated.
Its because of the timestamp attached with the date. User Floor(Field). This will remove the time portion attached to the date.
Many thanks. That worked perfectly.
Retrieving data ...