Answers.Body: <p>Lots of things like this can now be done with SearchKit.  If you were searching for those who had died in the last 30 days, you could use <a href="https://dmaster.demo.civicrm.org/civicrm/admin/search#/create/Contact?params=%7B%22version%22:4,%22select%22:%5B%22id%22,%22display_name%22%5D,%22orderBy%22:%7B%7D,%22where%22:%5B%5B%22deceased_date%22,%22%3D%22,%22ending_30.day%22%5D%5D,%22groupBy%22:%5B%5D,%22join%22:%5B%5D,%22having%22:%5B%5D%7D" rel="nofollow noreferrer">this</a></p>
  <p>But if you switch to 'Created Date' you don't get the same options.</p>
  <p>The <code>birth_date</code> and <code>deceased_date</code> fields are of the <code>date</code> type but <code>created_date</code> and <code>modified_date</code> are of type <code>timestamp</code> which are handled differently.</p>
  <p>There has been a lot of focus recently on dates vs timestamps so I'd suggest creating an issue <a href="https://lab.civicrm.org/dev/core/-/issues?scope=all&amp;state=opened&amp;search=searchkit" rel="nofollow noreferrer">here</a> requesting that timestamps can be searched with date ranges as dates are.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-05T14:48:23.783Z
Answers.Text: Thanks for the explainer Aidan.
Answers.UserDisplayName: Craig Almond
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-05-03T22:05:35.353Z
Answers.Text: This bug in SearchKit is now fixed for v5.50: https://github.com/civicrm/civicrm-core/pull/23335
Answers.UserDisplayName: Coleman
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-05T09:08:04.047Z
Answers.LastActivityDate: 2022-04-05T09:08:04.047Z
Answers.UserDisplayName: Aidan
Body: <p>This question was asked in October 2020. The answer was to use Drupal or Data Processor. We're using WordPress and we don't have the expertise to use Data Porcessor. Have there been any work-arounds developed in the past 18 months?
  I tried creating a Smart Group but the filters for Created Date asks for fixed dates, not relative dates.</p>
  <p>CiviCRM 5.45.0 on WordPress 5.9.2</p>
  
Tags: <civireport><searchkit>
Title: How do I create a report that displays Contacts created in the last (say) 30 days?
ThreadText: # How do I create a report that displays Contacts created in the last (say) 30 days?
  
  (Asked by: username_0 on 2022-04-04)
  
  This question was asked in October 2020. The answer was to use Drupal or Data Processor. We're using WordPress and we don't have the expertise to use Data Porcessor. Have there been any work-arounds developed in the past 18 months?
  I tried creating a Smart Group but the filters for Created Date asks for fixed dates, not relative dates.
  
  CiviCRM 5.45.0 on WordPress 5.9.2
  
  **Tags:** civireport, searchkit
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-04-05. Score: 2 | Accepted answer
  
  Lots of things like this can now be done with SearchKit. If you were searching for those who had died in the last 30 days, you could use [this](https://dmaster.demo.civicrm.org/civicrm/admin/search#/create/Contact?params=%7B%22version%22:4,%22select%22:%5B%22id%22,%22display_name%22%5D,%22orderBy%22:%7B%7D,%22where%22:%5B%5B%22deceased_date%22,%22%3D%22,%22ending_30.day%22%5D%5D,%22groupBy%22:%5B%5D,%22join%22:%5B%5D,%22having%22:%5B%5D%7D)
  
  But if you switch to 'Created Date' you don't get the same options.
  
  The `birth_date` and `deceased_date` fields are of the `date` type but `created_date` and `modified_date` are of type `timestamp` which are handled differently.
  
  There has been a lot of focus recently on dates vs timestamps so I'd suggest creating an issue [here](https://lab.civicrm.org/dev/core/-/issues?scope=all&state=opened&search=searchkit) requesting that timestamps can be searched with date ranges as dates are.
  
  > **Comments:**
  > **username_2**: Thanks for the explainer username_1.  
  > **username_3**: This bug in SearchKit is now fixed for v5.50: https://github.com/civicrm/civicrm-core/pull/23335  
  
  ---
  
  