topic Group by date not working in App Development

Group by date not working

BenjaminCoe1440 — Wed, 30 Nov 2022 10:56:01 GMT

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

Re: Group by date not working

BenjaminCoe1440 — Wed, 30 Nov 2022 10:58:46 GMT

Re: Group by date not working

Or — Wed, 30 Nov 2022 11:02:10 GMT

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.