Answers.Body: <p><code>dateCreated</code> and <code>dateUpdated</code> are pretty standard columns that you can find in pretty much every Craft database table. They store the date in which the row was created and last updated, respectively.</p>
  
  <p><code>dateModified</code> is an assets-specific thing, and that stores the time that the <em>file</em> was last modified, according to the file system.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2014-07-27T16:29:26.267Z
Answers.Text: Thanks. So dateUpdated is the attribute to order by if I want to produce a list of 'new' assets?
Answers.UserDisplayName: Bruce Johnson
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2014-07-28T00:02:57.603Z
Answers.Text: @BruceJohnson Probably `dateCreated`, since `dateUpdated` will get updated whenever you make changes on your asset’s metadata.
Answers.UserDisplayName: Brandon Kelly
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2014-07-28T00:42:41.750Z
Answers.Text: I should have mentioned it before but that's exactly the behaviour I'm looking for. I want the most "newly updated" assets, if you like.
Answers.UserDisplayName: Bruce Johnson
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2014-07-28T02:04:52.130Z
Answers.Text: In that case `dateUpdated` is the way to go!
Answers.UserDisplayName: Brandon Kelly
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2014-07-25T23:03:45.847Z
Answers.LastActivityDate: 2014-07-26T00:47:26.250Z
Answers.LastEditDate: 2014-07-26T00:47:26.250Z
Answers.UserDisplayName: Brandon Kelly
Body: <p>Can someone explain exactly what each of the above refers to when talking about assets? In particular, the difference between dateModified and dateUpdated.</p>
  
Tags: <assets>
Title: What is the difference between dateModified, dateCreated and dateUpdated?
ThreadText: # What is the difference between dateModified, dateCreated and dateUpdated?
  
  (Asked by: username_0 on 2014-07-25)
  
  Can someone explain exactly what each of the above refers to when talking about assets? In particular, the difference between dateModified and dateUpdated.
  
  **Tags:** assets
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2014-07-25. Score: 8 | Accepted answer
  
  `dateCreated` and `dateUpdated` are pretty standard columns that you can find in pretty much every Craft database table. They store the date in which the row was created and last updated, respectively.
  
  `dateModified` is an assets-specific thing, and that stores the time that the *file* was last modified, according to the file system.
  
  > **Comments:**
  > **username_0**: Thanks. So dateUpdated is the attribute to order by if I want to produce a list of 'new' assets?  
  > **username_1**: @username_0 Probably `dateCreated`, since `dateUpdated` will get updated whenever you make changes on your asset’s metadata.  
  > **username_0**: I should have mentioned it before but that's exactly the behaviour I'm looking for. I want the most "newly updated" assets, if you like.  
  > **username_1**: In that case `dateUpdated` is the way to go!  
  
  ---
  
  