date field should store the date in a standardized format

[apexdodge]

Our date field for the content item stores the date in the format selected in the admin settings.

This is normally fine, but I realize there is an edge case: What happens if the admins change their mind after populating the website with content, and now want the date format to be different. So they go into admin settings and change the date format. This will result in some date fields being stored as the old option so this causes a problem.

Solution:

We should store all date field as yyyy-MM-dd and perform all calculations as such in queries, but we convert to the desired format in admin settings in-memory.

This would require a database migration script, so we'll save this for a 1.x release.