Reports - based on Last Week?

Hi Jessica Linstrot,

I am not sure how you would do that with the reports-builder but you can use Advanced Reports (support.sugarcrm.com/.../index.html) with a custom query:

SELECT
 (curdate() - INTERVAL((WEEKDAY(curdate()))+7) DAY) as monday_last_week.
 (curdate() - INTERVAL((WEEKDAY(curdate()))+1) DAY) as sunday_last_week

So your report query could look something like:

SELECT * FROM leads
WHERE 
  deleted = 0
  AND date_entered >= (curdate() - INTERVAL((WEEKDAY(curdate()))+7) DAY)
  AND date_entered < (curdate() - INTERVAL((WEEKDAY(curdate()))+1) DAY)
ORDER BY date_entered ASC

I used Leads for easy testing in MySQL Workbench since we create leads daily.

FrancescaS

Hi Jessica Linstrot,

I am not sure how you would do that with the reports-builder but you can use Advanced Reports (support.sugarcrm.com/.../index.html) with a custom query:

SELECT
 (curdate() - INTERVAL((WEEKDAY(curdate()))+7) DAY) as monday_last_week.
 (curdate() - INTERVAL((WEEKDAY(curdate()))+1) DAY) as sunday_last_week

So your report query could look something like:

SELECT * FROM leads
WHERE 
  deleted = 0
  AND date_entered >= (curdate() - INTERVAL((WEEKDAY(curdate()))+7) DAY)
  AND date_entered < (curdate() - INTERVAL((WEEKDAY(curdate()))+1) DAY)
ORDER BY date_entered ASC

I used Leads for easy testing in MySQL Workbench since we create leads daily.

FrancescaS

Hi Francesca Shiekh,

Thanks for your information.  Unfortunately, I don't know how to do SQL queries.  Is there any way you know of to capture this information in the regular Reports module?

Thanks!