Click “New” Choose “Formula” Click “Next” Enter Field label Choose “Number” Click “Next” Enter “TODAY () - LastActivityDate” inside the formula box
Full Answer
How do I get the last 7 days in soql?
Using LAST_N_DAYS:7 in SOQL will return all records where the date starts from 12:00:00 AM (user Local Time Zone) of the current day and continues for the last 7 days. SELECT Id, Name, CreatedDate FROM Account WHERE CreatedDate = LAST_N_DAYS:7 ORDER BY CreatedDate DESC.
Why are my reports returning different results by last n days?
Any Reports attempting to filter results by "Last n days" within the Report's Filter logic will return different results than the same report filtered by "Last n Days" in the Time Frame section. Result: If today is Jan-7, the Time Frame will be Jan-1 through Jan-7
What is the difference between last_n_days and last_week in soql?
Using LAST_N_DAYS:7 in SOQL will return all records where the date starts from 12:00:00 AM (user Local Time Zone) of the current day and continues for the last 7 days. If today is Friday, 22 Nov 2013, using LAST_N_DAYS:7 will return the account created between 16 - 22 Nov 2013, while LAST_WEEK will return the account between 10 - 16 Nov 2013.
Does last_n_days include Today's data?
For the number n provided, starts 00:00:00 of the current day and continues for the past n days. To be more specific, isn't LAST_N_DAYS in fact LAST_N_DAYS + 1 (Today)? Show activity on this post. In contradiction to what the current documentation claims, you can observe that the LAST_N_DAYS date literal includes today's data.
Date Formats
A fieldExpression uses different date formats for date and dateTime fields. If you specify a dateTime format in a query, you can filter only on dateTime fields. Similarly, if you specify a date format value, you can filter only on date fields.
Date Literals
A fieldExpression can use a date literal to compare a range of values to the value in a date or dateTime field. Each literal is a range of time beginning with midnight (00:00:00). To find a value within the range, use =. To find values on either side of the range, use > or <.
What time does SOQL return?
Using criteria LAST_WEEK in SOQL will return all records where the date starts from 12:00:00 AM (user Local Time Zone) on the first day of the week before the most recent first day of the week and continues for seven full days. The first day of the week is determined by your locale.
What time does N_DAYS_AGO:7 return?
Using N_DAYS_AGO:7 in SOQL will return all records where the date starts from 12:00:00 AM (user Local Time Zone) on the day 7 days before the current day and continues for 24 hours. (The range does not include today.)
