Discussions

Expand all | Collapse all

Filter Report Based on Created Date

  • 1.  Filter Report Based on Created Date

    Posted 03-05-2020 17:12
    Does anyone know if it is possible to create a filter that shows records created between certain dates?  

    Thanks....

    ------------------------------
    Greg Sieber
    ------------------------------


  • 2.  RE: Filter Report Based on Created Date

    Posted 03-05-2020 17:23
    Edited by Austin K 03-05-2020 17:23
    There are many ways. If you know the exact start and end date you can do this filter block in a report. You would want both of them to be used to make sure it is in an All block. Otherwise it won't show the range you want. 

    [Date Created] - is on or after - <date>
    [Date Created] - is on or before - <date>

    This is usually how I do ask the user reports for a date range but it depends. You can also do "is during" and match that up with the current or previous week/month/day(s).