Forum Academy Marketplace Showcase Pricing Features

Current datetime format in database

Hello.
I assumed that it was enough to attribute a date format to a “Date” data item to display it in the format requested in the given database. But I always have an error as can be seen in the screenshot.
How to do ?
Thank you

image

Ok… the field Date de Modification has to be text…

This value is already saved for you. Look at the DB, there’s a “date/time modified” field already

Side note on time, what you are saving can’t be used for any further date manipulations or checking. Only for displaying that time.

And that time won’t show correctly if another user from a different timezone were to view it. They’d see it as you did which may produce unwanted results.

It’s usually best practice to save a date as a date and use the :format as only when you’re showing it to a human

1 Like