Date/time field types

3 posts by 2 authors in: Forums > CMS Builder
Last Post: June 1, 2021   (RSS)

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