I need to create a field which contains the date an entity/node was created. I know some people achieve this by using a bit of code in their template, but I need this to be a real, accessible field I can use on the entity/node display, as well as in Views (sort, filter, etc). Additionally I would like a field for the last modified date.
How would I do this properly in Drupal?
We did create a bit of SQL that we ran in PHPMyAdmin (it was a one time script, we need to schedule it to be run daily), but I have a feeling I could be doing something in Drupal. Am I wrong?