Print Page | Close Window

Last 24 Hours Formula

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21715
Printed Date: 14 Mar 2025 at 4:00pm


Topic: Last 24 Hours Formula
Posted By: lorimack21
Subject: Last 24 Hours Formula
Date Posted: 02 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!



Replies:
Posted By: praveeng
Date Posted: 04 Oct 2015 at 10:02pm
Hi,

use below formula in Record selection:

Dateadd ("h",-24,currentdatetime)

--Praveen G

-------------
Praveen Guntuka,
praveen_guntuka@yahoo.com



Print Page | Close Window