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!

Dave Edis - Senior Developer
interactivetools.com

By andreasml - June 1, 2021 - edited: June 1, 2021

Hi Dave,

It works!

Thanks a lot,

Andreas