Date/time field types
I am using some date/time field types in my sections. When I extract the data in a spreadsheet (Excel), it is not possible to make any calculations using the date data. I notice that the data for each field include both date and time details although I have chosen to display only dates, and I wonder whether it is the reason for this conflict. Is it possible to save only date data without time details? Or is there anything else I could do to solve this problem?
We use a MySQL datetime field to allow storing of date and/or date time.
If the date times are "00:00:00" you could search and replace them on export, or alternatively look into how to get just the date from a datetime field in excel.
For example the excel datevalue function such as: =DATEVALUE("1/1/2021 5:05:05") or =DATEVALUE(B6)
Hope that helps!