Who posted in: running a query with date() not showing the data

Member name Posts
amre 2
June7 1