Ok, that's useful to know, thank you.

Kind regards,

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,

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

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,

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