Answers.Body: <p>The transaction_date field lives in civicrm_financial_item. Not sure that helps you much though.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-27T11:16:34.243Z
Answers.Text: No It doesn't help - it seems that the date is able to be selected in the report filter but it doesn't work. Seems to me to be an error. I am only a 'configurer' and not a 'developer' unfortunately so I am not able to help solve the problem. All I can do is report it.
Answers.UserDisplayName: Martin Fuggle
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-26T07:03:44.390Z
Answers.LastActivityDate: 2016-04-26T07:03:44.390Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>When I create a report of contributions I can select a filter on 'Receive Date' of yesterday and any transactions with yesterday's Receive Date will be displayed. If I select a filter on 'Transaction Date' of yesterday no transactions are displayed even though there are transactions with a Transaction Date of yesterday.</p>
  
  <p>In looking at the Contribution Table the transaction date is not shown in the table.</p>
  
  <p>Can someone throw some light on this apparent issue?</p>
  
Tags: <civireport>
Title: Report with filter 'yesterday' produces no result
ThreadText: # Report with filter 'yesterday' produces no result
  
  (Asked by: username_0 on 2016-04-26)
  
  When I create a report of contributions I can select a filter on 'Receive Date' of yesterday and any transactions with yesterday's Receive Date will be displayed. If I select a filter on 'Transaction Date' of yesterday no transactions are displayed even though there are transactions with a Transaction Date of yesterday.
  
  In looking at the Contribution Table the transaction date is not shown in the table.
  
  Can someone throw some light on this apparent issue?
  
  **Tags:** civireport
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-04-26. Score: 1
  
  The transaction\_date field lives in civicrm\_financial\_item. Not sure that helps you much though.
  
  > **Comments:**
  > **username_0**: No It doesn't help - it seems that the date is able to be selected in the report filter but it doesn't work. Seems to me to be an error. I am only a 'configurer' and not a 'developer' unfortunately so I am not able to help solve the problem. All I can do is report it.  
  
  ---
  
  