Date/time field types
3 posts by 2 authors in: Forums > CMS Builder
Last Post: June 1, 2021 (RSS)
By andreasml - May 25, 2021
Hi
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?
Kind regards,
Andreas Lazaris
By Dave - May 31, 2021
Hi Andreas,
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!
interactivetools.com