Group by date not working

[BenjaminCoe1440]

Ok, so I have a table of meter readings that I want to see summed by date. But the individual readings are made up of the 48 readings that comprise a day. For some reason, even though the field DateId is formatted as 'DD/MM/YYYY', the table won't show the readings sum per day

if(RptTime='00:00',Date(ReadingDateTime-1,'DD/MM/YYYY'),date(ReadingDateTime,'DD/MM/YYYY')) as DateId

@vinieme12

[Or · Accepted solution]

Date() does not change the underlying value, which will maintain its original time aspect. Use either DayName(Field) or Date(Floor(Field)) to remove the time aspect.