Skip to main content
Hi All,

 

I have a daily report that runs at 10pm for activities for the date, however if anyone enters any activites after the report is run it doesn't get captured in that day's or next day's report. The report is based on the Last Modified Date field (which shows in this format: 5/26/2016 11:34 AM ). 

 

Currently my report has it for Last Modified Date equal to Today.

 

I'd like it to be for Today and Yesterday after 10:30pm. How can I do it? 

 

Thank you very much in advance.
2 respuestas
  1. 3 jun 2016, 7:19 p.m.
    You'll probably need to create a Formula(Number) field that retuns the Number of Hours between the DataTime field and the Current DateTime and use that as your Report Filter Criteria like this

     

    Datatype = Formula

     

    Result = Number(1-2 decimals depneding on the precision you want)

    (NOW() -  LastModifiedDate ) * 24

     

    (NOW() -  LastModifiedDate ) = Number of Days

     

    * 24 = Number of Hours