I want to use group by date but the date field always seems to store the current time - which means the group by has separate groups for a given date because each record has a different time. I tried removing the default time format H:i and leaving it blank, which is not accepted, inserting 00:00:00 and also of setting the date format to d-m-Y 00:00:00. This last format correctly displays the date but when I click save, it changes to the current time. Oddly enough when I edit the record, using the same form, the date is saved with a time of 00:00:00 and the record is correctly grouped with all the others of the same date.
What do I need to do to ensure the record has a time of 00:00:00 when first saved ? Thanks
What do I need to do to ensure the record has a time of 00:00:00 when first saved ? Thanks