Date field changed

5 posts by 2 authors in: Forums > CMS Builder
Last Post: May 6, 2013   (RSS)

By gversion - May 4, 2013

Hello,

Under "Section Editors" I have just changed a date field so that it no longer includes hours, minutes and seconds.

Consequently, the day and month of over 900 records in the database table seem to have been changed.

Is there any way I can fix the dates?

Thank you,

Greg

By Jason - May 6, 2013

Hi Greg,

Can you let me know how the day/months are now different?  Do you have a backup of the database prior to the change?

If you could send in a second level request (www.interactivetools.com/support) we can take a closer look and see what's going on.

Hope this helps,

---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By gversion - May 6, 2013

Hi Jason,

Thanks for your message. I think I may have been mistaken - the date fields seem ok on further inspection.

Are the days and months meant to be preserved when changing the option to choose the minutes and seconds?

Regards,

Greg

By Jason - May 6, 2013

Hi Greg,

Great, glad to hear that's working.  When you change the format to not display time, the time is still being stored in the database (even if it's just 00:00:00), so changing the field to use or not use time shouldn't affect the day, month, or year values.

Hope this helps,

---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/