You need to sign in to do that
Don't have an account?
brarob
Report Filter: Leads Created in Past 48 Hours?
I can't seem to create a report that will allow us to show leads created in the past 48 or 72 hours. Anyone have ideas on how to add this to the filter?
- B
You would need to create a custom Formula(Number) field that evaluates the Created Date/Time and compares it to NOW() and returns a Number. Then use the value in this Custom Field as the criteria for your Report.
Otherwise, with a Standard Report you can only evaluate the Created Date in whole days (Last 2 Days, Last 3 Days, etc...).
All Answers
You would need to create a custom Formula(Number) field that evaluates the Created Date/Time and compares it to NOW() and returns a Number. Then use the value in this Custom Field as the criteria for your Report.
Otherwise, with a Standard Report you can only evaluate the Created Date in whole days (Last 2 Days, Last 3 Days, etc...).
Yeah, Stevemo is right.
I did exactly that recently when creating a report for looking at Accounts created in the past 24 hours.
Check out my blog post - How to create a "Past 24 hours" flexible report - for a full step by step explanation of the process.