Last 24 Hours Formula

Printed From: Crystal Reports Book — Forum Name: Report Design

Posted By: lorimack21 — 2 Oct 2015 at 8:39am

Hello,

I am trying to build a formula to pull data from the last 24 hours.

Any code that I can use that will pull that data from the date/time field?

Thanks!

Posted By: praveeng — 4 Oct 2015 at 10:02pm

Hi,

use below formula in Record selection:

Dateadd ("h",-24,currentdatetime)

--Praveen G